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 |
learntsql
524 Posts |
Posted - 2012-02-02 : 00:46:22
|
Hi All,I have one main report and that report contains links to some child reports.Main report contains almost 8-10 parameters to get the output(some are optional)Main report output contains stateids and names.Once i get the output and when i click on any link in main reporti shuld carry all the stateids to that child report and should get the details for all these stateids in child report.Child report contians some parameters and one of the parameters are StateIDs,so i need to load this StateIDs multivalue text box with the stateids of main report output.Please suggest me the way to develop.TIA. |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-02 : 10:32:36
|
use =join(parameters!parentparametername.value)as value for child parameter in jump to link------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
learntsql
524 Posts |
Posted - 2012-02-02 : 23:50:03
|
Thanks Visakh. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-02 : 23:56:11
|
welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|