How to create a linked SQL Server Reporting Services parametrized report and use it with cached option in a schedule


A linked report is created on the base of an existing report and retains its original settings.
It inherits layout and data source properties. The other settings like security, parameters, locations, subscriptions and schedules can be modified.
Linked reports are created whenever there is a need to deploy an existing reporting with different settings.

To get to SQL Server Reporting Services the first step is to open the Report Manager URL from Reporting Services Configuration Manager.
User-added image

Browse to the Home - Portrait - Portrait Reports - Dialog folder and select D_Dialog_Details and select the Create Linked Report option.

After defining a new name and confirming that with the OK button, a linked report is created and ready to be modified.

To get the parametrized report, the parameters have to be predefined which prevents them from being changed later on. This is done in the Parameters section.

Cache a temporary copy of the report in Processing Options creates a temporary copy of the report in a cache when a user first opens the report. Subsequent users who run the report within the caching report will get the cached copy of the report - this improves performance because the report is returned from the cache rather than being processed again.

This behavior can be added to a schedule where the date and time to expire a cached report is specified.

This type of prepared report can be universally shared within an organization using its URL link as a way of supplying information about a business prospect.

UPDATED:  April 12, 2017