| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | ms.custom | |
|---|---|---|---|---|---|---|---|---|---|
Add a snapshot to report history - Reporting Services |
Learn details about how to manually add a snapshot to report history in SQL Server Reporting Services (SSRS). |
maggiesMSFT |
maggies |
09/25/2024 |
reporting-services |
reporting-services |
conceptual |
|
Report history is a collection of report snapshots that you create over time. A report snapshot is a report that contains layout information and query results retrieved at a specific point in time. Unlike on-demand reports, which get up-to-date query results when you select the report, report snapshots are processed on a schedule and then saved to a report server. When you select a report snapshot for viewing, the report server retrieves the stored report from the report server database. Then, it shows the data and layout that were current for the report at the time the snapshot was created.
Report snapshots aren't saved in a particular rendering format. Instead, report snapshots are rendered in a final viewing format (such as HTML) only when a user or an application requests it. Deferred rendering makes a snapshot portable. The report can be rendered in the correct format for the requesting device or Web browser.
::: moniker range="=sql-server-2016"
-
In Report Manager, navigate to the Contents page. Hover over the item that you want to view history for, and select the arrow.
-
In the menu, choose View Report History.
-
Select New Snapshot. A new snapshot is created in the When Run column.
[!NOTE] To enable creating snapshots, the administrator must configure the report history to Allow history to be created manually. For more information, see Limit Report History (Report Manager).
-
Select Apply.
-
For a report that is already configured to run as a report execution snapshot, you can set other properties to save a copy of the snapshot to report history each time you refresh the snapshot.
-
In Report Manager, navigate to the Contents page. Hover over the item that you want to view history for, and select the arrow.
-
In the menu, choose Manage.
-
Select Snapshot Options.
-
Select the Store all report execution snapshots in history checkbox.
-
Select Apply.
-
In Report Manager, navigate to the Contents page. Hover over the item that you want to view history for, and select the arrow.
-
In the menu, choose Manage.
-
Select Snapshot Options.
-
Select the Use the following schedule to add snapshots to report history checkbox. Perform one of the following actions:
-
Select Report-specific schedule. Fill in the schedule details, select the start and end dates for the schedule, and then choose OK.
-
Select Shared schedule. From the list, choose the schedule you prefer.
-
-
Select Apply.
- Configure execution properties for a report (report manager)
- Limit report history (report manager)
- Schedules
- Report manager (SSRS native mode)
::: moniker-end
::: moniker range=">=sql-server-2017"
-
In the web portal, navigate to the item that you want to view history for and right-click it.
-
In the menu, choose Manage.
-
Select the History snapshots tab.
-
On the History snapshots page, select the New history snapshot. A new snapshot appears with the current date and time in the Created column.
[!NOTE] To enable creating snapshots, the administrator must configure the report history to Allow history to be created manually. For more information, see Limit report history (web portal).
-
In the web portal, navigate to the item that you want to view history for and right-click it.
-
In the menu, choose Manage.
-
Select the History snapshots tab.
-
On the History snapshots page, select Schedule and settings.
-
In the Schedule section, select one or both of the following options if at least one choice isn't selected:
- Create history snapshots on a schedule
- Allow people to create snapshots manually
-
In the Advanced section, select Retain all history snapshots.
-
Optionally, select the Save cache snapshots in report history as well checkbox.
-
Select Apply to save the settings.
[!NOTE]
To enable creating snapshots, the administrator must configure the report history to Allow history to be created manually. For more information, see Limit report history (web portal). -
Select Apply.
-
For a report that is already configured to run as a report execution snapshot, you can set other properties to save a copy of the snapshot to report history each time you refresh the snapshot.
-
In the web portal, navigate to the item that you want to view history for and right-click it.
-
In the menu, choose Manage.
-
Select the History snapshots tab.
-
On the History snapshots page, select Schedule and settings.
-
In the Schedule section, select one or both of the following options if at least one choice isn't selected:
- Create history snapshots on a schedule
- Allow people to create snapshots manually
-
In the Advanced section, select Retain all history snapshots.
-
Optionally, select the Save cache snapshots in report history as well checkbox.
-
Select Apply to save the settings.
-
In the web portal, navigate to the item that you want to view history for and right-click it.
-
In the menu, choose Manage.
-
Select the History snapshots tab.
-
On the History snapshots page, select Schedule and settings.
-
Select the Use the following schedule to add snapshots to report history checkbox. Perform one of the following actions:
-
Select Report-specific schedule. Fill in the schedule details, choose the start and end dates for the schedule, and then select OK.
-
Select Shared schedule. From the list, choose the preferred schedule.
-
-
Select Apply.
- Configure execution properties for a report (web portal)
- Limit report history (web portal)
- Schedules
- The web portal (SSRS native mode)
::: moniker-end