Friday, March 08, 2013 8:18 PM
in my main report ,i have 1 field,what i want is if user create that link ,another report should open and main report should pass parameter to that report also.
how to create hyperlink .and all this report
Friday, March 08, 2013 8:36 PMBOL: " Drillthrough Report Links
A drillthrough report is a report that a user opens by clicking a link within another report. Drillthrough reports commonly contain details about an item that is contained in an original summary report. For example, you might have a sales summary report with a list of orders and sales totals. When a user clicks an order number in the summary list, another report opens that contains details about the order.
A drillthrough report typically contains parameters that are passed to it by the summary report. In the sales summary report example, the drillthrough report contains a parameter that takes the order as a value. The summary report includes a drillthrough report link for each order number, which opens the target detail report when clicked and passes the order ID to it. To view instructions about customizing drillthrough reports based on parameter values, see Working with Parameters in Reporting Services and InScope Function (Reporting Services).
Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012
- Edited by Kalman TothMicrosoft Community Contributor Friday, March 08, 2013 8:39 PM
Monday, March 11, 2013 9:41 AMModerator
Right-click the text-box->Text Box Properties->Action->check “Go to report”->select report in the drop-down list->click Add button to add parameter to pass value.
If you have any questions, please feel free to ask.
TechNet Community Support