Create a Linked Report
Applies To: SQL Server 2016
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. 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.
In Report Manager, navigate to the folder containing the report that you want to link to, and then open the options menu can click Create Linked Report.
Type a name for the new linked report. Optionally type a description.
To select a different folder for the report, 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).
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:
Open and Close a Report (Report Manager)
New Linked Report Page (Report Manager)
Choose Item Location Page (Report Manager)
General Properties Page, Reports (Report Manager)
Reporting Services Concepts (SSRS)
Report Manager (SSRS Native Mode)