Export (0) Print
Expand All
Expand Minimize

How to: View and Configure Report History (Management Studio)

SQL Server 2005

Updated: 17 July 2006

Report history is a collection of reports that contain data that was retrieved at specific points in time. Each report has its own report history that is stored on a report server. Report history is part of a report. If you delete or move a report, report history is also deleted or moved with it. Report history is enabled by default, but you can set options to make it unavailable, or change how report history is created and stored.

  1. Start Management Studio and connect to the report server.

  2. In Object Explorer, right-click the report server node.

  3. Click Properties.

  4. Click History. Configure your global report history preferences as follows:

    1. To save all snapshots in history, select Keep an unlimited number of snapshots in report history.
    2. To set limits on how many snapshots to keep in history, select Limit the copies of report history, and then specify the number of copies to keep. If you select 0, report history will not be created for any report on the report server.
  5. Click OK.

  1. Start Management Studio and connect to the report server.

  2. In Object Explorer, navigate to the folder containing the report that you want to configure history for. Reports are located under Home, or in a folder under Home.

  3. Right-click the report.

  4. Click Properties. The Report Properties page appears.

  5. In Report Properties, click History. Configure your report history preferences as follows:

    1. To allow snapshots to be created manually, select Allow history to be created manually. (Selected by default.)
    2. To save all snapshots in history, select Store all report execution snapshots in history.
    3. To schedule adding snapshots to history, select Add snapshots to history on the following schedule, and then click Configure. Configure your schedule preferences, and click OK.
    4. Set limits on how many snapshots to keep in history by clicking the appropriate radio button.
  6. Click OK.

  1. Start Management Studio and connect to the report server.

  2. In Object Explorer, navigate to a report. Reports are located under Home, or in a folder under Home.

  3. Expand the report folder.

  4. Expand the History folder to view report history.

  5. 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft