Friday, July 19, 2013
Reference parameter values in a text box without parameter fields.
You can add the parameter value of a parameter to a text field in you report but after adding you get next content in the text box:
[ERVCountries].[Country].&[Netherlands]
You only want to have: Netherlands
Solution: Change the reference expression to use .Label instead of .Value.
In this example use:
=Parameters!ERVCountriesCountry.Label(0)
To display multiple parameter values you an use next syntax:
="My own text: " + Join(Parameters!Country.Label,", ")
For more details about displaying multi value parameters click here for a more detailed blog post
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment