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.
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
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.
On Preview of the Report it will prompt for a parameter “CatID”. Provide the specific CatID the report will be generated as given below.
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.
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
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.
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
On Clicking on any of the “CategoryID” value of above Report a Linked Child Report will open as shown below.
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.
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”.
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 Asp.net
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