Report History Page (Report Manager)

Use the Report History page to view report snapshots that are generated and stored over time. Depending on options that are set on the report server, report history may contain only the more recent snapshots.

Report history is always viewed within the context of the report from which it originates. You cannot view the history of all reports on a report server in one place.

To generate report history, the report must be able to run unattended (that is, it must use stored credentials; parameterized reports must contain default parameter values for all parameters). Report history can be generated manually or as a scheduled operation. History properties on the report determine the ways in which report history can be created.

You can click a report history snapshot to view it. Snapshots that appear in report history are distinguished only by the date and time at which they were created. There is no visual indication to distinguish whether a snapshot was generated in response to a schedule or a manual operation.

Note

This feature is not available in every edition of SQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2012.

Use the following procedure to navigate to this location in the user interface (UI).

To open the Report History page

  1. Open Report Manager, and locate the report for which you want to view report snapshots.

  2. Hover over the report, and click the drop-down arrow.

  3. In the drop-down menu, click View Report History.

Options

  • Delete
    Click to delete one or more snapshots. Before clicking Delete, select the check box next to the snapshot that you want to delete.

  • New Snapshot
    Click to add a snapshot to report history. This button is available when you choose the option Allow history to be created manually on the History properties page of the report.

  • Last Run
    Displays the date and time at which the snapshot was created. Click a description to view a particular snapshot.

  • Size
    Displays the size of the report definition plus the data in the report. This value indicates how much space in the report server database is used by the report definition and data. The size of the rendered report, which includes formatting, is actually larger. The total size, indicated in parentheses, sums the sizes of all snapshots in the report history for the current report.

See Also

Tasks

View or Delete Report History (Report Manager)

Add a Snapshot to Report History (Report Manager)

Reference

General Properties Page, Reports (Report Manager)

Report Manager F1 Help

Snapshot Options Properties Page (Report Manager)