Click here to Skip to main content
11,790,953 members (63,047 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL-Server-2008 SSRS
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 27-Jan-13 23:30pm
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 at 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
0 OriginalGriff 410
1 ppolymorphe 385
2 Richard MacCutchan 118
3 Jochen Arndt 80
4 Maciej Los 70
0 OriginalGriff 1,329
1 Maciej Los 835
2 ppolymorphe 780
3 KrunalRohit 686
4 CPallini 661

Advertise | Privacy | Mobile
Web02 | 2.8.1509028.1 | Last Updated 22 Aug 2013
Copyright © CodeProject, 1999-2015
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