Thursday, April 19, 2012
How to display a multi value parameter in a text box in SSRS.
In my previous blog I described how you can pass a multi-value parameter to another SSRS report via drill through. After doing this, sometimes you want to show the used multi-value parameters in a text box. The solution for this is very simple. This can be achieved by using the JOIN function. I will explain with an example @Hostname as multi-value parameter.
Open the text box and define next expression:
="My own text: " + Join(Parameters!Hostname.Label,", ")
Other blog post about multi-value parameters: How to pass NULL value to a multi-value parameter in SSRS?
Picture: Milford Sound, New Zealand Dec 2011.
Labels:
multi-value,
parameter,
SQL 2008 R2,
sql 2012,
SSRS
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment