Click here to Skip to main content
13,291,084 members (68,592 online)
Rate this:
Please Sign up or sign in to vote.
Hi Friends ,

I need to create Linked report in SQL Reporting services.

Can you please any one help me for my request.


Arul R
Posted 28-Jan-13 0:30am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

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 on the report server when you want to create additional versions of an existing report.
Anh Nguyen Trong 22-Aug-13 23:45pm
you want to create link report only or create link report base on reference?
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

we have two report:
Orders - List of orders
OrderDetails - Order Details
we have the case study:
List Order will list all orders in database
in running, the user can click to orderid and OrderDetails will display the information of that order.
you do following the step:
Step 1:
-> Change the query to Select * From [Order Details] where OrderID=@OrderID
-> parameter @OrderID will be generated in Parameter category
-> You run this report alone, you have type orderid
Step 2
righ click orderID field
-> Text Box Properties.
-> choose action,
-> choose go to report,
-> specify a report : OrderDetails
-> Add parameter: Name: OrderID Value: OrderID
Now you run or preview order. You move mouse to orderID and click. you will get the orderDetails with OrderID

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.171207.1 | Last Updated 22 Aug 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100