How do I display the Description of a Parameter ?

[Siggy19]

In Crystal 8.5 I have a parameter from a Stored Procedure called @Check_Number.

It is a number from 1 to 13.

In Crystal, I have assigned descriptions to each of these values and set the parameter to only show the Description when prompting the user.

For example, value 1 has the description "Initial Check"

However, when I display the value of the parameter on the report, it shows the numeric value only.

Is there any way that I can display the description instead other than by hardcoding the available descriptions into a formula that uses a Select statement ?

Thanks.

 

[vidru]

Aside from the potential solution you've already come up with (hard-code the descriptions in Crystal... Case statements...), the only other suggestions I can think of are:

1) If the matching 'Description' for the CheckNumber parameter is stored in the database, return it as a column within the stored proc.

2) Again, if the Descriptions are stored in the db, create a subreport against the table/view that holds the descriptions, and link it to the CheckNumber parameter of the main report.

-dave