Show parameters

[Former Member]

We have a report where users pick multiple parameters.

I'd like to print what parameters they chose, obviously if I just put the parameter field in the footer it only shows one parameter. How can I get it to show all that wre chosen?

[Former Member · Accepted solution]

Hi zeb,

It's pretty simple. First you need to create a formula field. Paste the following code into the formula editor.

Join ( {?Parameter} , ', ' )

This function separates all value with a comma.

[Former Member · Accepted solution]

Sorted! Many thanks to all who responded!

[Former Member · Accepted solution]

After many fruitless hours trying to program this, it was all too easy, thanks to you guys...

[Former Member]

As Zane said use Join function to get all values in your footer.

Regards,

Sastry

[Former Member]

Hi Zeb

You would require array variables to store the multiple values.

For example you have different parameters like country, city and region and you have allowed multiple values to be selected at runtime. In this case you would need to define array variables to store the multiple values for country region and city.

I would suggest you to create separate formula field with array variable for each individual parameter.

Please let us know if your requirement is different from this.

Hope this helps!!!!

Regards

Sourashree