Displaying Multiple Parameter Selections as Text

[jbarbato]

Hi There! I am using Crystal XI.

I have a parameter called "?Discipline Group". The user is allowed to select multiple values for this parameter. If the user selects ?Discipline_Group = "Engineering" and "Construction", I would like the first page of the report to have the following...

"Discipline Group: Engineering, Construction"

If the user selects just "Engineering", It should have

"Discipline Group: Engineering"

The parameter works just fine, I am having trouble outputting this text. How do I go about doing this?

Thanks!

 

[Madawc]

You can display the parameter value as a field on your report. If this isn't suitable, do a formula field that tests the parameter and show that.

Madawc Williams (East Anglia, UK)

 

[jbarbato]

I am aware that I can put the parameter as a field on the report... It only shows the first selected value.

I can create a formula that tests if the parameter was left blank, but how do i create a formula to read all of the values in the parameter?

 

[Turkbear]

Hi,
Parameters that allow for multiple values store those values in an array, so to display it you must use a formula to convert the values into a character-separated string..

@ShowParam
Join({?Discipline Group},',')

If Values are :
"Engineering" and "Construction"

The formula would output:
Engineering,Construction

Place the Formula in the Page or Report header to display what was chosen..





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

 

[jraheja]

Also remember to set title to ‘can grow’ so that all parameters selected are displayed.