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:


You only want to have: Netherlands

Solution: Change the reference expression to use .Label instead of .Value.
In this example use:


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

1 comment:

Craig Bones said...

Oh, thank you for the tip! It is really important and very useful. Maybe it's just the small thing, but often you can't complete the task without this small edition. So I'm really happy that you're explaining this to your followers, It's really cool. The only resource I know that does the same - is the Essaydune site. I really recommend it toyou and to everyone who is interested in stuff like that.