How to display the multi-value parameter in a text box in reporting services? -- sql server reporting services

Paul
12/18/2005 6:09:08 PM

I am using Sql 2005 Reporting Services and Visual Studio 2005 to create the
reports. One of the report has the multi-value parameters to filter out the
data for the report. Everything is working fine and I want to create a text
box to display the multi-value parameters user selected for the report. So
far I put in the expression to the text box "Parameter!XXX.value(0)" and it
only shows the first value in the multi-value combo box. Also how to put in
the default value "Select All" to the multi-value combo box. Thanks.

ramesh.rakam NO[at]SPAM gmail.com
1/15/2006 8:04:12 PM

you can use

=Join(Parameters!Title.Value, ", "))

to display all the multi-value parameters .

ramesh rakam

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : How to display the multi-value parameter in a text box in reporting services?