Home > SSRS > SSRS – Linked report

SSRS – Linked report

Linked report is a great way to present the additional business information to the existing higher granularity report. We could only request the additional lower granularity information in an additional report.
Here I am using the previously developed report as a linked report, please visit the previous post for additional information of linked report development.
 
Step 1: Source queries of report and parameter
 

  
-- Sales Order Liked Report dataset
USE [AdventureWorksDW2008R2]
SELECT  FIS.SalesOrderNumber,
        CONVERT (DATE, CAST(FIS.OrderDateKey AS VARCHAR)) AS [OrderDate]
FROM    dbo.FactInternetSales AS FIS
WHERE   ProductKey = @ProductID
ORDER BY OrderDate DESC

-- Parameter dataset
SELECT DISTINCT
        ProductKey AS [ProductID]
FROM    dbo.FactInternetSales
ORDER BY ProductID

 
Step 2: Developed a standard tablix report with datasets including the parameter as

 
Step 3: The parameter properties setup are similar to the standard development process as

 
Step 4: Link the child report to the main report as

Select the column to assign the child report
Right click -> placeholder properties -> Actions

Option 1: select the Go to report and select the child report need to link to the report
Option 2: Passing the parameter value from the report to child report

 
Step 5: Open the child report parameter properties to setup the visibility properties

Option 3: setup the parameter properties at child report so that the passing parameter value from the actual report will assign to child report behind the scenes

 
Step 6: Run the report, select the Product ID parameter value. The report view comes with the selected parameter value
On the report data view, select any of the value i.e. SO75087 selected

 
Step 7: The linked report will be executed and open in a new report window by passing the parameter value behind the scenes i.e. SO75087

 
Points to consider:
 
1. The linked report developed based on existing report developed on previous post
2. The child package needs to updated the parameter properties setup as discussed in step 5
3. I am planning to use the linked report in future for sub report presentation

Advertisements
Categories: SSRS Tags:
  1. Tendai
    August 23, 2013 at 9:01 pm

    How do you pass multiple parameter values to the sub report. For Example you need to see the sales details for orders of the product SO75087,between 2008-08-28 to 2008-08-29. How do you make the sub report accept the product ID, and also the date range select from the initial report.

    • October 6, 2013 at 12:57 pm

      Hi
      We need to join all the multi parameters using JOIN function for passing multiple parameter to sub-report

  2. Abed
    August 27, 2013 at 12:02 am

    Hello I have question regarding linked reports
    How can the same process shown above be done if we have a Cube as a data source, and the parameters being passed are MDX based as in :
    [Product].[Product].[All]

    Thank

    • October 6, 2013 at 12:58 pm

      Hi
      We have to pass the member key i.e. UniqueName of the members to sub-reports

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: