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 2005 Forums
 Analysis Server and Reporting Services (2005)
 Passing Multiple Values into a subreport

Author  Topic 

asqldeveloper
Starting Member

17 Posts

Posted - 2008-05-07 : 15:39:36
I am doing report development against OLAP (Cube). I have a parameter which is a multi-value parameter, and I need to pass this as a parameter into a sub-report (pass all the values selected in this multi-value from the main report to sub report parameter).

Is this even possible? If yes how do I achieve this.

Currenty I sent like Fields!Region.Value(0), but I want to send actually Fields!Region.Value() (meaning all selected).

Any help ASAP is appreciated.

QAZAFI
Yak Posting Veteran

50 Posts

Posted - 2008-05-07 : 18:11:59
You can send those value using join(Fields!Region.Value,",")
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-08 : 14:27:22
You can try like this also;-

http://www.sqlservercentral.com/articles/Reporting+Services/62731/
Go to Top of Page

asqldeveloper
Starting Member

17 Posts

Posted - 2008-05-09 : 00:11:50
Thanks for the link. This illustrates how to use it against OLTP. Do you have experience with report development against OLAP? If yes, are you willing to contact me Visak?
Go to Top of Page
   

- Advertisement -