Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: Alternate value display Post Reply Post New Topic
Author Message
Beebt77
Newbie
Newbie
Avatar

Joined: 03 Aug 2012
Location: United States
Online Status: Offline
Posts: 8
Quote Beebt77 Replybullet Topic: Alternate value display
    Posted: 07 Feb 2013 at 9:11am
Hello All,
 
I am hoping that someone can help me, I am trying to create a formula for an item in a table to display with  an alternate name/value. 
 
Example  in the table  the data is identified with  numbers such as 3  and 5, and I would like 3 to equal yes and 5 to  equal No.
 
If I want to  select all "yes" data, and the return not read the number 3;  where and how do I put the formula for 3 to display as yes.
 
ThanksCry
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 07 Feb 2013 at 11:42am
Create a formula for the field.  It will look something like this:
 
If {myTable.myField} = 3 then 'Yes'
else if {myTable.myField} = 5 then 'No'
 
Then use the formula on your report instead of the field.
 
-Dell


Edited by hilfy - 07 Feb 2013 at 11:42am
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.