Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 Linking from one report to another

Author  Topic 

MaritimeMadness
Starting Member

10 Posts

Posted - 2009-06-17 : 14:47:08
I have two reports and I would like to run one based off the other. A subreport is an option however I would like to pass a selected parameter and open the other report.

ie

1st report returns ticket #'s

I would like the users to be able to click on a ticket # and inturn report #2 which has the parameter of ticket # would run based on the selected ticket #.

Is this possible? Does anyone have any examples to follow?

MaritimeMadness
Starting Member

10 Posts

Posted - 2009-06-17 : 15:38:51
Answered my own question.

Very Simple.

Added the report (#2) that I wanted to link to, to my project.

Select the field that will act as the parameter in the 1st report and go to its properties.

Select the Navigation tab and choose jump to report. Select report and and parameter.

Done.
Go to Top of Page
   

- Advertisement -