Thursday, May 21, 2015

SSRS report deployment error

A lot of error can pop up when we deploy the report from AX one of them is "User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.", below are some few place that you can check whether it's already being configured properly:
  • Check whether UAC has been properly set up (disable it for the fastest way)
  • Set respective user as administrator in SSRS server.
  • Check whether respective user has access rights to the SSRS folder
The easiest way to resolve this was to add the respective users to the whole SSRS site as "System admin" role on below location at your SSRS report manager

Wednesday, May 6, 2015

Dynamics AX 2012 SSRS changes not reflected after deployment

After we change the report format at Visual Studio and save it; sometimes when we deploy it from AX client it won't reflect the changes. I've spend quite some times to check why it's not reflected. There are few points that you can check :
  • Check whether Visual Studio properly save the report into AX (most cases)
    • Try to close the "Designer" before saving the report
    • Try to "Add to AOT" not only save
  • Deploy the report directly from Visual Studio (fast workaround)
  • Delete all *.auc file at respective users appData folder
You can always "compare" the report to see the changes.