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)
 How to bind multi value parameters dynamicallySSRS

Author  Topic 

bhushan_juare
Starting Member

45 Posts

Posted - 2013-04-12 : 07:26:32
Hi All,
I got stucked in SSRS report where there are five parameters for report
1) From Date
2) End Date
3) Market
4) Party
5) Segment
which has to be interlinked to each other i.e when user entered From Date, End Date there is no problem to show report output but
Actual problem starts when (I have given Market dataset parameter vlaues M000, M111, M222) and If User select Market = M000 then I want to display only those Party data set values (let say P111, P222, P333 etc) in the selection panel and When User select P111 Party he will get only those Segements which will have Party P111. Now I have tried in script as well in the design view of SSRS but I am not able to bind all above parameters dynamically and showing values in selection panel at run time.

Thanks,
Bhushan
   

- Advertisement -