How to: Create Report History (SharePoint Integrated Mode)

New: 12 December 2006

Report history is a collection of report snapshots that you create over time. Each snapshot is a copy of the report as it existed when it was created. It includes the layout information and data that was current for the report when the snapshot was created. The snapshot, however, is not stored in rendered form. When you open a snapshot in report history, it renders in HTML in the Report Viewer Web Part. After it is rendered, you can export it to other application formats.

To create report history, the report must be able to run unattended (that is, the report server must be able to run the report without user interaction). For instructions on how configure unattended processing, see How to: Schedule Report and Subscription Processing (SharePoint Integrated Mode). Creating report history requires that you have Edit Items permission on the library that contains the report. To view or delete report history, you must have View Versions or Delete Versions permissions.

To create report history on demand

  1. Point to the report.

  2. Click to display the down arrow, and then select View History.

  3. Click New Snapshot. If the button is not visible, it is because you do not have permission to create snapshots in report history.

  4. To view the snapshot you just created, select it from the list. Each snapshot is identified by a timestamp that shows when the snapshot was created. You cannot rename the snapshot, move it to another location, or modify it.

To schedule report history

  1. Point to the report.

  2. Click to display the down arrow, and then select Manage Processing Options.

  3. In History Snapshot Options, click Create report history snapshots on a schedule.

  4. If you have a shared schedule that contains the schedule information you want to use, select On a shared schedule and select the schedule you want to use. Otherwise, select On a custom schedule, and then select Configure to specify options to create report history on a recurring schedule.

To create report history when data is refreshed in a report

  1. Point to the report.

  2. Click to display the down arrow, and then select Manage Processing Options.

  3. In History Snapshot Options, click Store all report data snapshots in report history.

See Also

Tasks

How to: Schedule Report and Subscription Processing (SharePoint Integrated Mode)
How to: Set Processing Options (SharePoint Integrated Mode)

Concepts

Report Server How-to Topics (SharePoint Integrated Mode)
Viewing and Managing Report Server Items from a SharePoint Site
Managing Report History

Help and Information

Getting SQL Server 2005 Assistance