In our previous article we explained you about the creation of Report Execution Snapshot, and in this article we will show you the steps involved in creating a Report History Snapshot in SSRS with example. Report History Snapshot in SSRS will store a copy of a report in Report History tab at a specified time (scheduled time).
Before we start creating Snapshot in SSRS, Let me open my Report Manager to show the existing reports in 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
In order 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.
Once you select the Manage option, Report manager will navigate you to new page with 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 Report size.
Let me show you the default settings of the snapshots 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 check mark this option.
- Use the following schedules to add snapshot 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 beginning date to end data. You have to manually delete the unwanted snapshots to reduce the memory.
- Limit the copies of report history: This will limit the number of copies stored in the report history. By default it is 10, means 10 report snapshots will be saved.
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.
Once you click on the Configure button, report manager will navigate you to new page. We already explained these settings in our previous article. So, please refer Snapshot article to understand the same.
For the demonstration purpose, let me schedule for 1 minute, and stop time as August 2nd. In real-time it might be hourly, or Daily etc.
Click OK to close the snapshot scheduling, and Click Apply to close the Report History Snapshot in SSRS configuration.
Once you click Apply, following pop up window will be display. Click OK to close it.
Let me show you the Report History tab. As you can see there is a report snapshot at 12:15:06 PM.
Let me click on the snapshot to view the snapshot
As you can see the report preview coming from the report snapshot history.
Whenever you schedule something in Report Manger, a new Job will be automatically created at the Server level. This job will automatically executed as per we scheduled. Let me right-click on the Job and select the properties option from the context menu.
This will open following window will be opened. Please navigate to Schedules tab to check the Job schedules.
As you can see it is showing the schedule properties that we defined in the Report Manager.
Let me show you the log file of the Job. As you can see, it is executing every one minutes.
again, let me show you the report history. As you can see there are 7 report snapshots
Thank You for Visiting Our Blog