Thursday, April 19, 2012
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.