SSRS Report: Create a link to existing report - Create a Linked Report

Create a Linked Report

SQL Server 2014

Other Versions

0 out of 1 rated this helpful - Rate this topic

A linked report is a report server item that provides an access point to an existing report. Conceptually, it is similar to a program shortcut that you use to run a program or open a file.

A linked report is derived from an existing report and retains the original's report definition. 

To create a linked report

1. In Report Manager, navigate to the folder containing the existing report that you want to link to, and then open the options menu can click Create Linked Report.
2. Type a name for the new linked report. Optionally type a description.
3. To put a newly created Linked Report into your desired location, click Change Location. Click the folder you want to use, or type the folder name in the Location box. Click OK.  If you do not select a different folder, the linked report is created in the current folder (where the report it is based on is stored).
4. Click OK.  The linked report opens.
   A linked report's icon differs from other items managed by a report server. The following icon indicates a linked report:

Extra Note:

A linked report always inherits report layout and data source properties of the original report. All other properties and settings can be different from those of the original report, including security, parameters, location, subscriptions, and schedules.

You can create a linked report when you want to create additional versions of an existing report. For example, you could use a single regional sales report to create region-specific reports for all of your sales territories.

Although linked reports are typically based on parameterized reports, a parameterized report is not required. You can create linked reports whenever you want to deploy an existing report with different settings.