List valuses from Multi select parameter

[yeltom]

Hi,
I have a report where the user can select multiple values for one parameter. The report requires that the param selections be shown if reasonable. I am populating the parameter selection from a sproc using the id field for selection and the descriptor for display. My question is how can I get the descriptions to be shown in the report as opposed to the id values. Any help would be appreciated.

 

[Levora]

Hi,

If I understand you correctly:

In the Report Parameter screen, if you select the available values "from query" you have 2 fields: "value fields" and "label fields". You can select from the query which field is used to label and which one represente the values.

For example:

You create a Dataser:

SELECT userID, userName
FROM user

On the Report Parameter:
Value Fields: userID
Label Fields: userName

Hope that this helps.

 

[haroldholt]

If you have for example a mv parameter named 'building' then you can use this to show the labels for the selected items...

=join(Parameters!building.Label)

...and this for the values...
=join(Parameters!building.Value)

 

[haroldholt]

Almost forgot...you also have the option to delimit the output to give you prettier formatting (i.e. to wrap in a text box for example) if you use something like:

=join(Parameters!building.Label,",")