create hyperlink/subreport

Question

hi

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

Answer 1

BOL: " 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).

Any report that is stored on the report server can be a drillthrough report. You can add drillthrough links only to text boxes and images.

To view instructions about adding drillthrough links, see:
•How to: Add a Drillthrough Report Link (Report Designer)"

http://msdn.microsoft.com/en-us/library/ms159088(v=sql.90).aspx

---

Kalman Toth Database & OLAP Architect
Paperback / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

Answer 2

Hi Tsql,

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.

Reference: Adding Parameters to Pass to a Drillthrough Report (SSRS)

If you have any questions, please feel free to ask.

Regards,

---

Charlie Liao
TechNet Community Support