Thursday, October 5

SSRS Report - Can't see changes after deploying SSRS report AX 2012

Follow the following steps:
  1. If you are on R3, you have the Tools -> Caches -> Refresh report server;
  2. Also, do a Tools -> Caches -> Refresh elements and Tools -> Caches -> Refresh dictionary;
  3. If you have an AOT query, you can do a Restore on the query;
  4. Open the report in Visual Studio, and perform a Refresh on your dataset in the Datasets node;
  5. Also in Visual Studio perform a rebuild and a deploy of the report;
  6. Before step 5. you can check that the parameters you have for your report are the proper ones (if you've changed the data contract or the query);
  7. Depending on the decision to load the last values (controller.parmLoadFromSysLastValue) you want to do a Reset usage data;
  8. And last but not least, you want to do a Restore and then also a Deploy element on the report in the AOT.
If your still facing the issue then finally restart your SQL Server Reporting Services in service and run the report.

OR

sometimes you need to delete the report in the report document folder, then deploy again to get the latest version published. After that restart the SSRS service instance.

I hope that one of these helps.

No comments:

Post a Comment

Popular Posts