Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Specific Number for each record Post Reply Post New Topic
Author Message
clearvision
Newbie
Newbie


Joined: 27 Aug 2009
Online Status: Offline
Posts: 2
Quote clearvision Replybullet Topic: Specific Number for each record
    Posted: 27 Aug 2009 at 6:43am
Sorry, this is probably a crystal reports 101 question.  But I can't seem to get it to work properly. 
 
I have a report that is pulling 6 different records that are each in their own line.  I want a column in that line to show a certain number that isn't in a database anywhere for that specific cell depending on which record is in that line.  I need a formula that states if this record is on this line then put this number in this space?  Sorry if it's confusing.  Here is an example
 
Record A        $5000      $10000   525
 
So if Record A is on that line I want 525 to show in that space on so on for each record. 
 
But again, those numbers aren't in a datatbase.  They are numbers that I would like to be able to go into the formula and update on a quarterly basis


Edited by clearvision - 27 Aug 2009 at 6:51am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 27 Aug 2009 at 7:29am
Create a formula field as an if then if then ... statement to make the values then place it on the row wherever you want.
If {table.field}="Record A" then 525 else
if {table.field}="Record B" then 526 else
if {table.field}="Record C" then 527 else ...


Edited by DBlank - 27 Aug 2009 at 7:30am
IP IP Logged
clearvision
Newbie
Newbie


Joined: 27 Aug 2009
Online Status: Offline
Posts: 2
Quote clearvision Replybullet Posted: 27 Aug 2009 at 8:21am
Thanks so much! Worked perfectly!
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.063 seconds.