Showing 'Description' value of Parameter in Report

[kutoose]

Crystal Version 10.
DB : Oracle 9


I am having a set of Default parameters, which are week ending dates... This is how I set the values in the Parameter

Default
Values Description

1 01/11/2004
2 01/18/2004
3 01/25/2004
4 02/01/2004
5 02/08/2004

Now when the user selects the Description, I pass numeric fields to the report for calculation. How can I display the 'Description' in the report?

For example, if the user has selected 01/11/2004, I have to show '01/11/2004' instead of 1

Thanks !


kutoose@yahoo.com

 

[kskid]

See thread149-965110

 

[scottostanek]

No easy solutions exist I think.

To do this, export your parameters definitions and open that file in notepad, like this:

%%%%ShowDescOnly 0
1 test
2 foo
3 monkey
4 shines

Make a formula and wrap the case statement around the above:

select {?tester}
case 1 : "test"
case 2 : "foo"
case 3 : "monkey"
case 4 : "shines"

At least this does make it less likely the two sets disagree in their content by accident...

Scotto the Unwise

 

[scottostanek]

Whoops. Forgot to hit the check syntax. Since my initial param is a string those case statements need to be wrapped in "" too

case "1" : "test"

and so on...
Scotto the Unwise

 

[kutoose]

Thanks wichitakid !

That worked !

kutoose@yahoo.com