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

2 comments:

touneen said...

joya shoes 585u2jdmxx685 outdoor,INSOLES,Joya Shoe Care,walking,fashion sneaker,boots joya shoes 328u8jvdrh705

Michael Alex said...

The specific changes that you must make depend on the structure of your database. Btw thanks for an knowledgeable information, weather i am looking for Buy Essay Uk
writer appreciate your help