I just started using SQL Server 2005 Reporting Services. I am unable to find the information on how to access the reports which are stored in the snapshot history table which run on a schedule everyday.

Filed under: Reporting Services, SQL Server 2005 — Ari Weil at 3:08 am on Thursday, February 7, 2008

You should definitely read about Report Snapshots in MSDN to ensure you have all the necessary background information on report snapshots before you try to dive too deep. Once you’ve gone through that, you can find instructions on accessing report snapshots and snapshot histories here:

  • Finding and Viewing Reports in Report Manager
    • To select a report, search for a report by name or description, or browse report server folders to find the report you want. In Reporting Services, published reports and folders are represented as a hierarchy similar to those of file systems and Web sites. To find the reports that you want to run, you can browse through the folder hierarchy. Not all reports that are visible in the folder hierarchy are accessible. Some reports may prompt you for your user name and password to determine whether you can access the data source for the report.
  • How to: View and Configure Report History (Management Studio)
    • Start Management Studio and connect to the report server.
    • In Object Explorer, navigate to a report. Reports are located under Home, or in a folder under Home.
    • Expand the report folder.
    • Expand the History folder to view report history.
    • To view an individual snapshot, right-click the snapshot you want to view, and then click View Snapshot. A Web browser opens and displays the snapshot.

Hope that helps.

2 Comments »

Comment by Ari Weil

February 11, 2008 @ 2:20 am

If you’re looking for some tutorial-style information the following articles from Database Journal go into great detail:
Snapshot Reports I: Report Manager Perspective
Snapshot Reports II: SQL Server Management Studio Perspective

Comment by nitin

September 10, 2008 @ 4:58 am

no this did not help in any way.

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>