Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Chr & Previous Function Formula Post Reply Post New Topic
Author Message
MDAVIS
Newbie
Newbie
Avatar

Joined: 09 Feb 2017
Location: United States
Online Status: Offline
Posts: 1
Quote MDAVIS Replybullet Topic: Chr & Previous Function Formula
    Posted: 03 Mar 2017 at 3:06am
    My table.field is called {AC_ECONOMIC.KEYWORD}. Below is showing my KEYWORD results, CHR_FLAG formula and next to it is what I would like my end result to look like incorporating the CHR_FLAG formula. I am not attached to the CHR_FLAG formula so if there is a simpler or more efficient formula to use I am open to suggestions. Basically, I need a formula to replace the quote character with the previous KEYWORD. I first made a formula called CHR_FLAG
CHR_FLAG = IF {AC_ECONOMIC.KEYWORD} = CHR(34) THEN TRUE ELSE FALSE.


                 KEYWORD        CHR_FLAG      END RESULT
RECORD 1: GAS/OIL          FALSE            GAS/OIL
RECORD 2: "                     TRUE             GAS/OIL
RECORD 3: "                     TRUE              GAS/OIL
RECORD 4: "                     TRUE             GAS/OIL
RECORD 5: OIL                  FALSE            OIL
RECORD 6: "                     TRUE              OIL
RECORD 7: GAS                 FALSE             GAS
RECORD 8: WTR/OIL           FALSE            WTR/OIL
ECT...

I then made a formula attempting to use Previous function and it did not work fully. Any help would be greatly appreciated!

Thanks,
Micdavis

MDAVIS
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Mar 2017 at 6:51am
Is this only for visual output or are you expecting to do more calculations on the "end result" field?
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.