Jaa


Managing Report History

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

Note

Report history is not supported in SQL Server 2005 Express Edition with Advanced Services. For more information about features in this edition, see Reporting Services in SQL Server 2005 Express Edition with Advanced Services.

Viewing and Managing Report History

To view or manage report history, use Report Manager or Management Studio. You can view report history through the tabbed History page that appears when you navigate to a report in Report Manager, or through the History folder that opens below a report in Management Studio.

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 Configuring Report History Properties.

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. For more information, see Rendering a Report Using URL Access.

See Also

Tasks

How to: Open and Close a Report (Report Manager)
How to: Open and Close a Report (Management Studio)

Concepts

Saving Reports
Creating, Modifying, and Deleting Snapshots in Report History
Finding and Viewing Reports in Report Manager

Other Resources

Managing Report Server Content
Report History Page (Report Manager)

Help and Information

Getting SQL Server 2005 Assistance