Display Parameters selected from a drop-down

[mdole]

Hello,

I am using Crystal Reports with an SAP-BW database. I am using the following formula to display the parameters selected from a dropdown list:

WhilePrintingRecords;
StringVar Values;
NumberVar Counter := count({?YourParameter});

While Counter >= 1
Do
(Values := Values + {?YourParameter}[Counter] + ", ";
Counter := Counter - 1);
Values [1 to (Length(Values)-1)]


Instead of getting the description I would like to have displayed I get the following output:
[0BBP_PROPO].[I1011],
[0BBP_PROPO].[I1020],
[0BBP_PROPO].[I1015],
[0BBP_PROPO].[I1009], etc.

Where [0BBP_PROPRO] is the field I am selecting on and [I1011], etc. are the codes for the values i've selected. What I would like to see are the long descriptions...

Does anyone have experience in this area?

Any help would be greatly appreciated.

 

[synapsevampire]

A simpler means is:

join({?YourParameter},",&quot

for a comma delimited list, or:

join({?YourParameter},","+chr(13))

for a comma delimited plus a carriage return list.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[mdole]

I get the same output if I use "join"... :-(

 

[synapsevampire]

Oooooh, I get it, you mean the descriptions for the parameters as opposed to the code values that the user selects, sorry, I misunderstood.

I'm afraid you need to reload the parameters so that the description is the value and vice versa.

Then in the Display, select Description.

The user will see the code values (as you want), and you can get the description by using the join.

Crystal doesn't allow you to extract the Description, only display it within the parm prompt.

I know, it sux...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com