Extracting the description from the parameter array

[synapsevampire]

Any idea how to do it?

I have a parameter which has an ID number for use with the pass through SQL. I have a description also to simplify the selection for the user (I only display the description in the parameter list).

I want to display what was chosen, but NOT the ID.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[HowardHammerman]

k,

Cystal does not allow you to get the description of the parameter field into your report.

Of course you could create a formula that decodes the parameter choices to the descrption and then display that.
I like the SELECT function for this. For example:

select {?param}
case "A" : "Apples"
case "B" : "Bananas"
default : "Pears"

(I have not had breakfast yet!)

I hope this helps. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[synapsevampire]

Thanks Howard, just as I feared.

I currently do a manual conversion from abbr to text, but that is bad long term because I intend to dynamically update pick lists, and I really don't want any business rules in the reports.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[HowardHammerman]

Of course you could create a table with the translation of the abreviation to the description. However, Crystal won't let you link on the paremeter field except by doing a sub-report. Uggh.

An then you will have another table to maintain. Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269