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

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.

To configure report history for a report server

  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.

To configure report history for a specific report

  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.

To view report history

  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.

See Also

Tasks

How to: Register and Connect to a Report Server (Management Studio)
How to: Schedule a Report Snapshot (Management Studio)
How to: Add a Snapshot to Report History (Report Manager)

Concepts

Configuring Report History Properties
Managing Report History
Report Server Folder Hierarchy
Report Server How-to Topics

Other Resources

Report History Page (Report Manager)
Report History Methods
Report Properties (History Page)

Help and Information

Getting SQL Server 2005 Assistance