Click here to Skip to main content
Rate this: bad
good
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.
 
Regards
 
Arul R
Posted 27-Jan-13 23:30pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

  Permalink  
Rate this: bad
good
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.
  Permalink  
Comments
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
good
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
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 766
1 OriginalGriff 345
2 CPallini 200
3 PIEBALDconsult 150
4 Magic Wonder 131
0 OriginalGriff 5,795
1 Sergey Alexandrovich Kryukov 5,028
2 CPallini 4,700
3 George Jonsson 3,142
4 Gihan Liyanage 2,450


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