Monday, March 04, 2013 4:56 PM
I am experiencing odd behaviour on a report where I'm using an Execution Snapshot. This is the basic sequence of events that caused the fault.
1. I created a Report using Visual Studio 2005. (a basic bar chart report, nothing fancy).
2. I then deployed the report to the Reporting Services website.
3. I then set up an execution snapshot, telling it to run on 1st of Each Month. At this point, I had a snapshot.
4. I then made a change to the report (I added point labels), and deployed it.
Now, when I go to view the snapshot report, it shows both the old version (no point labels) and the new version side-by-side. When I export the report to file (e.g. PDF), it actually exports correctly.
I have tried deleting the report from Reporting Services, and redeploying, but that made no difference.
I also tried renaming the RDL file and re-deploying - This also made no difference.
I have also tried telling RS to re-create the snapshot - This also made no difference.
I have never seen this behaviour before, but it seems that editing & re-deploying a report which runs from a snapshot can cause problems. Can anyone advise as to how I would fix this?
Tuesday, March 05, 2013 7:01 AMModerator
From you description, after you change the report and redeploy it to report server, when you click the report to run it, it shows both of the old version (no point labels) and the new version side-by-side, right? In this case, please delete all the snapshots in the History tab. And select “Always run this report with the most recent data” in the “Execution” tab. Then click the report to run using the most recent data. In this case the report should only show the new version. Then change the render mode back to “render this report from a report execution snapshot”.
Hope this helps.
TechNet Community Support
Monday, April 29, 2013 8:28 AM
This didn't work for me - Firstly, there were no snapshots to delete.
When I changed the execution mode to “Always run this report with the most recent data” in the “Execution” tab, and ran the report, it still showed the two versions of the report side-by-side.
Do you have any other suggestions?