Chapter-16-Creating SSRS Linked Report

Linked reports(Child) can be seen as a shortcut to the original report(Parent). Generally it is developed by creating a link on parent report. On clicking the parent report child report is opened on the same window dependent on the parameter values passed.

Download Full Tutorial for Chapter-16-Creating-SSRS-Linked-Report-files

Download Source Code for Chapter-16-Creating SSRS Linked Report

Step-1: Designed a simple tabular SSRS Report using the following query as it was desigend in “Chapter1-Creating a basic SSRS Report”.

SELECT CategoryID,CategoryName,Description,Picture FROM Categories

Report Created in Chapter1-Creating a basic SSRS Report
Report Created in Chapter1 – Creating a basic SSRS Report

Name this report as “Chapter-16-Creating SSRS Linked Report-Parent”, now create a Tabular child report with the following query

SELECT ProductID,ProductName,QuantityPerUnit,UnitPrice,UnitsInStock  FROM Products where CategoryID=@CatID

With name “Chapter-16-Creating SSRS Linked Report-Child” as shown in the image.

Linking SSRS Reports

On Preview of the Report it will prompt for a parameter “CatID”. Provide the specific CatID the report will be generated as given below.

Preview of SSRS Report
Preview of Report

Step-2: Open the report “Chapter-16-Creating SSRS Linked Report-Child” in the design view and right click on “CategoryID” and choose “Text Box Properties..” as shown.

right click on “CategoryID” and choose “Text Box Properties..”
Right click on “CategoryID” and choose “Text Box Properties..”

A Text Box Properties window will appear now goto “Action” option as shown and choose the following options

Enable as an action: Go to Report

Specify a Report :Chapter-16-Creating SSRS Linked Report-Child

Change action option
Change action option

And click on add button to add a Parameter to run the report and set the parameter as shown above on the screen and click on ok. Now Preview the Parent Report it will look as.

Preview the Parent Report
Preview Parent Report

The column “CategoryID” is not shown as Hyperlink so, change the color of the CategoryID to “Dark Blue” its font weigh to Bold and select Underline from the standard toolbar as shown. The Preview of the Report will look as

Dark Blue Child Link from Parent Report

On Clicking on any of the “CategoryID” value  of above Report a Linked Child Report will open as shown below.

Child Report Linked to Parent Report in SSRS
Child Report Linked to Parent Report in SSRS

Go to Design view of the child report and Double Click on Parameter “CatID” a Report parameter Properties will be opened and choose “Hidden” from Select Parameter Visibility and click ok.

Select Parameter Visibility and click ok
Select Parameter Visibility and click ok

Now Preview the Parent Report and click again on the “CategoryID” now child report will open without showing any parameter value and parameter is passed to child report internally. This completes “Chapter-16-Creating SSRS Linked Report”.

Preview of Final Report
Preview of Final Report

Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS
Chapter-6: Creating a Drill Down Report in SSRS
Chapter-7: Working with expressions and custom code in SSRS
Chapter-8-SSRS (Reporting Services) Working with Calculated fields
Chapter-9-Sorting of Column and Custom Paging in SSRS
Chapter-10 : Creating and Deploying Web Services for SSRS
Chapter-11 : Creating SSRS Report by consuming Web Service Data Source
Chapter-12 : Working with Data Bars in SSRS
Chapter-13-Displaying Color in Data Bar Based on Condition
Chapter-14- Displaying Data Labels along with Data Bars in SSRS
Chapter-15-Displaying Indicators in SSRS
Chapter-16-Creating SSRS Linked Report
Chapter-17 Adding or Creating Drop Down Parameter List in SSRS
Chapter-18 Creating Group above or stepped report in SSRS
Chapter-19-Creating Multi Value Parameter Report in SSRS
Chapter-20-Using CSS Stylesheet in SSRS



Leave a Reply

Your email address will not be published. Required fields are marked *