Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Cached Reports in SSRS

by suresh

The Cached Reports in SSRS is a saved copy of an already processed report. If your report generated with massive data or it designed from a large dataset, then it’s time-consuming to call the same report again and again. In these situations, you can create an SSRS cached report. And by this, we can save the report rendering time.

Before we start creating cached reports in SSRS, Let me open my Report Server to show the existing reports on our server.

Cached Reports in SSRS 1

In this article, we will show you the steps involved in creating cached reports in SSRS with an example.

For this SSRS Cached Reports demonstration, we use the report from the Create Bar Chart in SSRS Report Builder article. So please refer to the same to understand the SSRS Report data.

Cached Reports in SSRS example

To create a SSRS cached report on a bar chart, Click the down arrow beside the Bar Chart to open the menu items. Please select the Manage option.

Cached Reports in SSRS 2

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 this report (advanced operations, I must say). Under the properties tab, it will show the Report Created, modified dates, and the Report size.

Cached Reports in SSRS 3

You can create a Cached Reports in SSRS in multiple ways:

  • Using the processing Options
  • Cache Refresh Options

SSRS Cache Refresh Options

Please navigate yourself to Cache Refresh Options tab and select the New Cache refresh Plan option.

Cached Reports in SSRS 4

The following pop up message will display. Click the OK button

Cached Reports in SSRS 5

Once you click OK, it will ask you the description of the Cache report, and the cache refresh time.

Cached Reports in SSRS 6

We assigned the cached bar Chart as the description and clicked the Configure button

Cached Reports in SSRS 7

Once you click on the Configure button, report manager will navigate you to a new page. You can use this page to schedule the cache for SSRS Cached Reports.

  • Schedule Details: Use this section to schedule the cached report on Hourly, Daily, Weekly, Monthly, or Once in a lifetime. Don’t forget to mention the start time.
  • Start Date: please specify when you want to start the Report caching.
  • Stop this Schedule on: When you want to stop this cache.
Cached Reports in SSRS 8

For the SSRS Cached Reports demonstration purpose, let me scheduled for 1 minute.

Cached Reports in SSRS 9

Click OK to close the cache configuration.

Cached Reports in SSRS 10

From the below screenshot, see that we successfully created a New Cache refresh Plan to cache the SSRS report.

Cached Reports in SSRS 11

Let me edit the bar chart using the report builder by selecting the Edit in Report Builder option

Cached Reports in SSRS 12

Let me run the SSRS Cached Report. As you can see from the below screenshot, we had an Execution Time, and whenever we refresh (or re-run) the report the time will refresh

Cached Reports in SSRS 13

Now let me run the report from the Report Manager by clicking the Bar Chart

Cached Reports in SSRS 14

Let me refresh the report.

Cached Reports in SSRS 15

As you can see from the above screenshot, the execution time is not changing because it is displaying the SSRS Cached report. If you try after one minute, then the Execution time will be updated because we defined the cache time as 1 minute.

Cached reports in SSRS using Processing options

Let me show you the default settings of the processing option by selecting the PIE Chart because we already changed the cache option of the bar chart.

  • Do not Cache temporary copies of this report: By default, the Report server will assign this option. It means the report will always call the dataset, render, and then display a report with live data.
  • Cache a temporary Copy of the report. Expire copy of the report after a number of minutes: This option will cache the report by a given number of minutes.
  • Cache a temporary Copy of the report. Expire copy of the report on the following schedules: This option allows you to configure the schedule options. 
Cached Reports in SSRS 16

Now let me open the Bar Chart Processing Option. As you can see from the below screenshot, it is using the second cache option. This option is automatically selected by the report server, based on the Cache refresh options that we specified.

Cached Reports in SSRS 17

Let me open the SQL Server Management Studio to see what is happening in SQL Server. When you create a cache report in the report manager, a new job will create at the Server level. This job will automatically execute as we scheduled.

To see the schedule options, Right-click on the Job, and select the properties option from the context menu.

Cached Reports in SSRS 18

Once you click on the properties option in the context menu, the following window will open. Please navigate to Schedules tab to check the Job schedules.

Cached Reports in SSRS 19

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

Cached Reports in SSRS 20

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy