join({?Parameter},', ') - works for strings but not numbers 1

[swhitten]

I want to display all the choices a user selects for a parameter that allows multiple choices. I have successfully used join({?Parameter},', ') for string parameters, but now I am trying to use it for a parameter that is numbers rather than text. The join apparently wants text/string only? How can I get this to work for a parameter that has numbers instead of strings? Thanks!

 

[Turkbear]

Hi,
Try here:

faq767-810





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[swhitten]

Thanks for the help; those are good formulas to have handy. But my parameter is not a range; it's multiple number values. Still looking for the solution...

 

[Turkbear]

Hi,
Sorry, missed that, try this FAQ:

faq767-5684





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[swhitten]

Perfect! Thanks! This worked great!



Multiple Discrete values separated by a comma:

whileprintingrecords;
stringvar Output:="";
numbervar Counter;
For Counter := 1 to ubound({?MyNumericParameter}) do(
Output:= Output& totext({?MyNumericParameter}[Counter],0,"")& ","
);
left(Output,len(Output)-1)