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 |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-11-28 : 16:07:18
|
| In a SSRS 2008 r2 dashboard, the user can click on various links to jump to various ssrs reports that are on the report server. When this occurs I would like to be able to pass the 'same' parameters selected by the user from report to report. Thus can you show me how to pass the 'original selected parameters' and pass the value from report to report so the values are used on the report the user jumps to? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-28 : 23:02:36
|
| you just need to use jump to report or jump to url and use parameters!paramname.value for each of parameters in main report which you want pass to second report.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-11-29 : 23:48:43
|
| You are saying that I can pass the parameter value from one report to the next report. How do you set this up? Do you need a dataset? Can you give me specific code on how to pass the parameter values. I cannot get this to work. Thanks! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-11-30 : 01:49:36
|
quote:
Originally posted by jassie
You are saying that I can pass the parameter value from one report to the next report. How do you set this up? Do you need a dataset? Can you give me specific code on how to pass the parameter values. I cannot get this to work. Thanks!
yep..its straightforwardin place where you need to pass parameter to other report just use Parameters!FirstReportParamName.value and map it to corresponding parameter in the child report.If using jump to url append Parameters!FirstReportParamName.value to expression where you need to pass param value------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
ssrs 2008 r2 pass parmater value from rpt to rpt