Multiple Parameter Display Help 1

[excalibur78]

Trying to figure out how to display a multiple select parameter in the exact order its in the array in the report header. Also The array will just contain numbers 1,2, or 3 and I need to change them to names. 1 should = Product so in the report header I'd like to display the array as it was made by the user with numbers replaced by names. Any help would be great. Thanks ahead of time.

 

[Naith]

Assuming you're on v8 or 8.5, you can use the join command.

Join({?Your_Parameter})

Later,
<N>

 

[Naith]

Whoops. I forgot to respond to the rest of your query. Sorry!

To convert your numbers to names, you can use a formula to look at the first formula I gave you, and then convert it:

if '7' in {@AforeMentioned_Join_Formula} then replace({@AforeMentioned_Join_Formula},'7','Seven')

If you're on an earlier version of Crystal, the 'replace' and 'join' functions won't be available to you. So, just holler if you need an alternative solution.

Naith

 

[cjmartin]

Naith,

I'm on 7.0 and attempting to display multiple parameters (array) in the report header. Any suggestions for those that don't have the 'join' function available to them?

Thanks!

 

[dgillz]

If count(array)=1 then array[1] else
if count(array)=2 then array[1]+&quot;, &quot;=Array[2] else.....

Continue this logic until you reach the maximum number of elements your could reasonably expect in the array. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[cjmartin]

Works great! Thanks dgillz!