Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Change value in detail line from numeric words to text w
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00980928
Message ID:
00980932
Views:
46
This message has been marked as a message which has helped to the initial question of the thread.
>Crystal Version 10 minor problem. Easy for you...
>
>I have this code in a formula in the detail line of a Crystal Report -
>If {ES10.STD_NUMB} = "01"
>Then "Printing Standard";
>If {ES10.STD_NUMB} = "02"
>Then "Special Standard";
>
>The field ES10.STD_NUMB is text, not numeric.
>
>I just want to show the words in quotes instead of the 01 or 02 in the detail line, but it's not working. Any ideas? I saw Crystal 10 has a text translation feature, but I don't think it's for this.
>
>Thanks ahead of time.

May be You should TRIM()(I can't remember what is the exect function in CR) the field.
If TRIM({ES10.STD_NUMB}) = "01" Then
   "Printing Standard";
If TRIM({ES10.STD_NUMB}) = "02" Then
   "Special Standard";
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform