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

5 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

unknown said...

Interesting blog on the Reference parameter. I also a need the information on these topic. Do you these reason I'm not cover the assignment taking online service from the cheap nursing assignment writing uk this is the one the best writer in the UK.

johnwade said...

I am reading blog on daily basis last time i was reading iphone 13 pro max price in pakistan 512gb, suddenly i found this blog, wonderfull explanation , and i think this article explains how to use forms in Access to enhance your use of parameters in queries, forms, and reports.

Anonymous said...

Types of slot machines - bonanza, traditional slots, egyptian, 777 scorching slots, fruits, loopy monkey and extra. Pacing in an excellent slot game is equally driven by a roller coaster of emotion, which maps to the VOLATILITY of the mathematics mannequin. A player has to lose as much if not more often than they win to make the winning feel higher. As was the case in many of} industries, casinos reevaluated every thing about their companies during the Covid shutdowns. A month earlier than the pandemic, in February 2020, there have been 139,753 machines. And in February 2022, the state’s casinos appeared to find out|to search out} its magic quantity utilizing the Goldilocks principle—and, for now, 122,247 slot 온라인카지노 machines is excellent.