Parameter Question 1

[gj0519]

Cr10 Dev SQL 2005

I have a parameter where a user may select multiple values. My issue is when I try to display all the values on the report I am only getting the first one that was selected. The options I have selected are Allow multiple values and Discrete Value(s). Not sure why when 1 or more values is selected only the first one shows up.

Thanks,

GJ

 

[lbass]

If the parameter is a string, you can use a formula like this:

join({?parm},", ")

If it is a number or date, please tell us.

-LB

 

[MJRBIM]

The multiple-value creates an ARRAY, so you need to use a FORMULA to display it...

Display_Multi_Param
join(({?PARAM_MULTI}),", ")

You then insert that formula into the report to display all the values you selected.

 

[gj0519]

I just found the answer on Ken Hamady's site which is exactly what you guys posted. It is a string Parameter.

Thanks,

GJ