Click here to Skip to main content
15,891,513 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi Friends ,

I need to create Linked report in SQL Reporting services.

Can you please any one help me for my request.

Regards

Arul R
Posted

 
Share this answer
 
SQL
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.
 
Share this answer
 
Comments
Anh Nguyen Trong 22-Aug-13 23:45pm    
you want to create link report only or create link report base on reference?
CSS
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
 
Share this answer
 

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900