Export (0) Print
Expand All

Managing Report History

SQL Server 2000

Report history is a collection of previously run copies of a report. You can use report history to maintain a record of a report over time.

Report history is not intended for reports that contain confidential or personal data. For this reason, report history can include only those reports that query a data source using a single set of credentials (either stored credentials or credentials used for unattended report execution) that are available to all users who run a report.

Report history is an extension of a report. If you move a report, report history moves with it. However, if you modify a report or delete its data source, existing report history is preserved. Report history consists of report snapshots, instances of a report that contain layout information and data obtained from an external data source at specific points in time. Each snapshot in report history captures a report as it was when the snapshot was created. If you change the layout or delete the data source, snapshots in report history remain intact. For more information about report snapshots, see Report Snapshots.

Viewing and Managing Report History

You can view report history through the tabbed History page that appears when you navigate to a report in Report Manager. Any user who has access to a report can view report history for that report. These permissions are provided by the "View reports" task. You can only view report history for one report at a time. You cannot view in one place all the history of all reports stored in the report server database.

You can manage report history by setting properties that determine how report history is created and stored. You can set properties at the server level or for individual reports. Managing report history is supported through the "Manage report history" task. For more information, see Setting Report History Properties.

To view or manage report history, use Report Manager. For more information about opening a report and the pages you use to view report history, see How to open and close a report and Report History Page.

Viewing Report History Snapshots Through a URL

You can isolate a single snapshot from report history to view it separately or to send it to a recipient through e-mail. To do this, you must access the report through its URL and attach a rendering parameter that identifies the snapshot you want. The following example URL illustrates the syntax:


The rs:historyID rendering parameter specifies that the specific report history snapshot be retrieved from report history. The value indicates which report snapshot to return. The date is in the format YYYY-MM-DDTHH:MM:SS based on the International Organization for Standardization (ISO) 8601 standard.

See Also

Archiving Reports

Creating, Modifying, and Deleting Snapshots in Report History

Report Manager

Report Snapshots

Viewing Reports with Report Manager

Managing Report Server Content

© 2015 Microsoft