Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
RS2005 Report with Execution Snapshot shows two reports - bug?

Resposta Proposta RS2005 Report with Execution Snapshot shows two reports - bug?

  • Monday, March 04, 2013 4:56 PM
     
     
    Sign In to Vote
    0

    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?

     

All Replies

  • Tuesday, March 05, 2013 7:01 AM
    Moderator
     
     Proposed
    Sign In to Vote
    0

    Hi Bobby,

    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.

    Regards,

    Charlie Liao
    TechNet Community Support

     
  • Monday, April 29, 2013 8:28 AM
     
     
    Sign In to Vote
    0

    Hi Charlie,

    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?