Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Display next for numbers. Post Reply Post New Topic
Author Message
debasisdas
Newbie
Newbie
Avatar

Joined: 06 Aug 2007
Location: India
Online Status: Offline
Posts: 6
Quote debasisdas Replybullet Topic: Display next for numbers.
    Posted: 17 Aug 2007 at 11:25pm
In my oracle table i have a number field which stores flag settings in number format. But on the report i want to display some text.
 
ex
---------
flag        display
------       ----------
1             Closed
2             Pending
3             repalced
......
.....
etc
 
how to achieve that.
 
 
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Aug 2007 at 11:07pm
You can use the Choose() function to do this:
Var := Choose({table.flag}, "Closed", "Pending", "Replaced");

I cover Crystal syntax functions in Chapter 7 of my new book.


Edited by BrianBischof - 20 Aug 2007 at 11:08pm
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.