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

Linked Reports in SSRS

by suresh

A Linked Report in SSRS is similar to a Program shortcut. And it is derived from an existing report in the report manager, and also retains the report definition. In this article, we will show you the step by step approach to create Linked Reports in SSRS with example.

Before we start to create linked reports in SSRS, Let me open my Report Manager to show the existing Data Sources, Datasets, and reports in our server.

For this SSRS linked report demonstration, we are going to use the previously created report called SSRS Dashboard, so refer to know the SSRS Report data.

Linked Reports in SSRS 1

Let me show you the Report Preview.

Linked Reports in SSRS 2

For example, the Sales Manager of the Bikes category had asked us to develop the above-shown report. After seeing the report, the Sales Manager of the Clothing department asked us to develop the same report for Clothing. In this situation, you don’t have to create a new report from scratch.

SQL Reporting services provide a concept called linked reports, and you can use the same concept to fulfill the requirements.

Create Linked Reports in SSRS Example

Before we start to create a linked report in SSRS, we have to change the filter settings. Because we are using the hard-coded value (Bikes) as the Dataset filter in the above-specified report.

In SSRS linked reports, we can’t change anything apart from the parameter values. So, let me convert the hard-coded value to a parameter. If you are already using the Parameter report, then start reading from Step 2

STEP 1: Click the down arrow beside the SSRS Dashboard report to open the menu items. Please select the Edit in Report Builder option from the menu items.

Linked Reports in SSRS 3

Once you select the Edit in Report Builder option, SSRS Report Builder will open.

Linked Reports in SSRS 4

First, let me create a Parameter that will hold the string Data. From the below screenshot, you can see that we are creating a parameter called Country, and its visibility is Hidden.

I suggest you to refer to Report Parameters to understand each property present in the following window.

Linked Reports in SSRS 5

Next, let me add the default parameter value as the Bikes.

Linked Reports in SSRS 6

Lastly, please replace the Dataset Filter from the hardcoded value with the parameter value. For this, please navigate to the Filters tab and click the Expression button.

Linked Reports in SSRS 7

After you click the Expression button, a new window will be opened to write an expression. Here, please select the parameter value as the value.

Linked Reports in SSRS 8

STEP 2: Click the down arrow beside the SSRS Dashboard report, and select the Create Linked Report… option from the menu items.

Linked Reports in SSRS 9

Once you select the Create Linked Report… option, the report manager will navigate you to the following window. Within the Properties tab we had:

  • Name: You can your own name as per your requirements.
  • Description: Please provide a description that describes the reporting functionality.
  • Location: Use this button to change the report location. Once you click this button, it will display the list of folders available in the report manager.

For now, we are saving the report in Home page, and its name as SSRS Linked Report, and Description as Dashboard For Clothing

Linked Reports in SSRS 10

Once you click the OK button, the report manager navigates to the newly created SSRS linked report preview.

Linked Reports in SSRS 11

We had successfully created a Linked report in SSRS, but we want the sales for the Clothing department. For this, we have to change the parameter value from Bikes to Clothing.

To change the parameter value, Click the down arrow beside the linked report to open the menu items. Please select the Manage option from the menu items.

Linked Reports in SSRS 12

Once you select the Manage option, the Report manager will navigate you to a new page with the following tabs.

Let me go to the parameters tab, and as you can see that, the report parameter default value is Bikes. Here, we have to change the default parameter value.

Linked Reports in SSRS 13

Let me change the value from Bikes to Clothing

Linked Reports in SSRS 14

Now, let me show you the report preview.

Linked Reports in SSRS 15

Above report is a Linked report of SSRS Dashboard report, and the filter value is Clothing (Not Bikes)

Edit Linked Reports in SSRS

After creating a linked report in SSRS, You might be tempted to edit the linked reports in report builder. Let me show you what will happen if I Edit the newly created linked report?.

To do this, click the down arrow beside the SSRS linked report, and select the Edit in Report Builder option from the menu items.

Linked Reports in SSRS 16

From the below screenshot, you can see it is throwing an error because we can’t edit the linked reports.

NOTE: Whatever changes you made in the Original report (i.e., SSRS Dashboard in this case) will automatically reflect in the Linked report in SSRS.

Linked Reports in SSRS 17

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