Display Multiple Value Parameters in column format

[tubbers]

Hi, I'm using Crystal Reports v10.

On my report, one of the parameters allows multiple selections (string). I want to be able to display these multiple selections in a columnar format in the header. Any suggestions on how I might do that?

I've successfully used the following formula to display the results in a long line, the problem is it gets rather confusing as the medication names are long. I thought displaying them on one line each would be easier to read:

IF {?DRUG ID} = "ALL MEDS" THEN "all Medications"
ELSE
     JOIN({?DRUG}, ", ")

which produces this:

for NALOXONE HCL 0.4MG/ML- 0.4 MG AMPUL, PENTAZOCINE-NALOXONE  1 TAB TAB

I'm looking for this sort of result:

for NALOXONE HCL 0.4MG/ML- 0.4 MG AMPUL
    PENTAZOCINE-NALOXONE  1 TAB TAB

I do not have the Crystal Repository for custom functions so cannot use cdFormatStringRangeArray, which is what one of my books tells me would work.

Thanks for the help.

 

[synapsevampire]

Use:

JOIN({?DRUG}, chr(13))

Make sure that you format the formula to CAN GROW.

-k

 

[tubbers]

Thank you. That was so simple!