Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List valuses from Multi select parameter

Status
Not open for further replies.

yeltom

Programmer
Sep 17, 2001
62
US
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.
 
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.

 
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)

 
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,",")
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top