parameter - browse field with multiple values allowed 3

[jdbppd]

How do you get the report to show all the values chosen by a user from a parameter with multiple values allowed in a browse field picklist? I want the title of my report to show what parameter values where chosen. As far as I can tell, putting the ?parameter field in the report only shows the first value chosen -- not any of the other multiple values that were chosen from the list. I would like to be able to separate the list of values chosen with a comma or colon (or whatever).

 

[vidru]

Use a formula...

If your multiple value parameter is a string use this formula:

//@dispStringParam
join({?StringParam},", ")

If it's a number, try this:

//@dispNumParam
numberVar j;
stringVar output := "";
for j := 1 to ubound({?NumParam}) do(
  if j = ubound({?NumParam}) then
    output := output + totext({?NumParam}[j], 0, "")
  else
    output := output + totext({?NumParam}[j], 0, "") + ", "
  );
output;

Then just place the formula on the report to see your comma separated parameter list.

-dave

 

[jdbppd]

works like a charm! thank you for your quick and helpful reply!!