Displaying multiple parameter values

[cathyg18]

Hi there,

I have a parameter that accepts multiple values, and want to display those values on the report header or footer. Placing the parameter itself in either of these places just displays the first value in the list. Is there a way to tell it to show ALL values selected?

Thanks,

Cathy

 

[lyanch]

That depends on the datatype. For strings it would be:

join({?param},",&quot to list them separated with commas. It needs to be less than 255 chars or it will fail

Lisa

 

[cathyg18]

Thanks Lisa.

If I put join({?param},",&quot in my report footer, it simply returns the words join({?param},",&quot.

Making a formula called PARAMLIST, the word 'join' is not recognized as a key word, and returns 'The rest of this does not appear to be part of the formula.'

I'm on Crystal v7. Does this make a difference?

Thanks

Cathy

 

[lyanch]

Again it will need to be less than 255 chars. But here is how to output a text array (which a multiple val param is).

In a formula place the following (replacing {?param} with your parameter)

local stringvar paramlist := "";
local numbervar i := 1;

paramlist := {?param}[1];

while i < count({?param}) do
(
i := i + 1;
paramlist := paramlist + &quot;, &quot; + {?param};
);

paramlist