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.
| Author |
Topic |
|
Peace2007
Posting Yak Master
239 Posts |
 Posted - 2008-07-20 : 06:45:58
|
| Hi, I need to navigate to another report when user clicks on a report field; this works fine but what shall I do if I want one row of the second field be displayed which one of its fields equals to the value of the hyper linked column of the first report. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-20 : 13:50:53
|
| Pass the value as a parameter to second report and filter the dataset by it to show only the required row. |
 |
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-07-21 : 01:21:32
|
| Thanks for the reply visakh!Actually, I set a parameter in the second report called Report_Parameter_0 and define it as internal and I keep the rest as default.in the first report I set the Report_Parameter_0 parameter in navigation tab. when at run time,I click on the hyper link it says: the report parameter Report_Parameter_0 is read-only and cannot be modified Could I know please where I'm wrong? |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-21 : 01:51:47
|
| Try changing it to hidden instead of internal. |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-07-21 : 02:14:43
|
The problem is resolved Thanks Besides, creating hidden parameter in the second report, a filter shall be set, which its value is the parameter's value |
|
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-21 : 02:35:03
|
| Are you using the "jump to report" setting? |
|
|
|
Peace2007
Posting Yak Master
239 Posts |
Posted - 2008-07-21 : 02:47:00
|
quote:
Originally posted by dexter.knudson
Are you using the "jump to report" setting?
yes |
|
|
|
|
|
|
Hyperlink