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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Pass Constant Value between two Reports

Author  Topic 

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-09-06 : 02:34:42
Hi,

I'm having a report, in which I display a list of names. When user clicks on a name I navigate to another report.
I need to display the clicked name on the 2nd report. Is there a way to pass it to the report?

dexter.knudson
Constraint Violating Yak Guru

260 Posts

Posted - 2008-09-07 : 17:21:16
One way to do it is to add a textbox to your report with the URL in it & pass the name as a parameter. When you add the textobx, right-mouse click on it, select properties -> Navigation & fill-in the Hyperlink action.
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 2008-09-08 : 06:27:31
thx dexter
Go to Top of Page
   

- Advertisement -