Report History Snapshot in SSRS

In our previous article, we explained to you about the creation of Report Execution Snapshot. In this article, we will show you the steps involved in creating a Report History Snapshot in SSRS with an example.

The Report History Snapshot in SSRS will store a copy of it in the Report History tab at a specified time (scheduled time).

Before we start creating a Report Snapshot in SSRS, Let me open my Report Manager to show the existing reports on our server. For this demonstration, we are going to use the previously created report called Page Breaks Example 2, so please refer the same to understand the Report data.

Create Report History Snapshot in SSRS

To create a Report History Snapshot in SSRS, Click the down arrow beside the Page Breaks Example 2 report to open the menu items. Please select the Manage option from the menu items.

Available charts in Report Manager

Once you select the Manage option, the Report manager will navigate you to a new page with the following tabs. You can use this page to manage the advanced setting of this report. Under the properties tab, it will show the Report Created user, created and modified dates, and the size.

Report Properties

Let me show you the default settings of the SSRS Report History Snapshot options page.

  • Allow Report History to be Created Manually: It allows you to create a report history.
  • Store All report snapshots in history: If you want to store the snapshots in Report History, then please checkmark this option.
  • Use the following schedules to add snapshots to history: This option allows you to configure the schedule options.

And under the Select the number of snapshots to keep:

  • Use Default Settings: This will use the master settings.
  • Keep an unlimited number of snapshots in report history: This will keep all the report snapshots from the beginning date to the end date. You have to delete the unwanted snapshots to reduce the memory manually.
  • Limit the copies of report history: This will limit the number of copies stored in the report history. By default, it is 10, which means 10 report snapshots will save.
Report Snapshot options

We check marked all the three option, and then limited the report snapshots to 10. Now, click on the Configure button to schedule the report snapshots.

Configure Report History Snapshot

Once you click on the Configure button, the report manager will navigate you to a new page. We already explained these settings in our previous article. So, please refer to Snapshot article to understand the same.

For the SSRS Report History Snapshot demonstration purpose, let me schedule this for 1 minute, and stop time as of August 2nd. In real-time, it might be hourly, or Daily, etc.

Schedule Report History Snapshot

Click OK to close the snapshot schedule, and Click Apply to close the Report History Snapshot in SSRS configuration.

Limit the Report History Snapshot Copies

Once you click on the Apply, the following pop up window will display. Click OK to close it.

Report History Snapshot 8

Let me show you the Report History tab. As you can see, there is a report snapshot at 12:15:06 PM.

Report History Tab to View them

Let me click on the SSRS Report History to view the snapshot

Latest Snapshot in the report history section

As you can see, the report preview coming from the report snapshot history.

View Report History Snapshot

Whenever you schedule something in Report Manager, a new Job will automatically create at the Server level. This Job will automatically execute as per we scheduled. Let me right-click on the Job and select the properties option from the context menu.

It will open the following window. Please navigate to the Schedules tab to check the Job schedules.

Report Snapshot in SQL Server

As you can see, it is showing the schedule properties that we defined in the Report Manager.

Schedule Report History Snapshot at Server Level

Let me show you the log file of the Job. As you can see, it is executing every one minute.

Report History Snapshot 14

Again, let me show you the report history. As you can see, there are 7 report snapshots

Report History Snapshot 15