Skip to Content
0
Former Member
Mar 20, 2009 at 05:42 PM

Display Multiple Parameter Values in Specific Format

76 Views

In CR XI, I have a string parameter that allows single and multiple values.

Values are Ward 1, Ward 2, Ward 3, Ward 4

Iu2019m still a newbie at Crystal and canu2019t figure out how to display the parameter values in the report header in a specific way. Join({?ward},",") works fine to show the values selected, but the format is awkward.

Would love to hear any suggestions on a formula that will display the parameter values in the header as follows:

For a single parameter value: Ward 1

For two parameter values: Wards 1 and 2

For three parameter values: Wards 1, 2 and 3

If all four values are selected: All Wards

Hope I made my question clear, and thanks in advance!