Click here to Skip to main content
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 28-Jan-13 0:30am
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
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 1


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

  Print Answers RSS
0 Zoltán Zörgő 185
1 Sergey Alexandrovich Kryukov 160
2 Peter Leow 100
3 CPallini 70
4 Ramza360 51
0 Zoltán Zörgő 80
1 the other paul 23
2 Shmuel Zang 10
3 Aarti Meswania 5
4 Member 11389991 -2

Advertise | Privacy | Mobile
Web04 | 2.8.150129.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