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 2008 Forums
 Analysis Server and Reporting Services (2008)
 Multi value parameter passing to child report?

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 report
i 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 MVP
http://visakhm.blogspot.com/

Go to Top of Page

learntsql

524 Posts

Posted - 2012-02-02 : 23:50:03
Thanks Visakh.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-02 : 23:56:11
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -