Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions  
Message Icon Topic: Shared String - Editing - Help Post Reply Post New Topic
Author Message
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 85
Quote BoltzGirl Replybullet Topic: Shared String - Editing - Help
    Posted: 09 Jul 2020 at 10:41am
I have a report that is using this formula currently.

shared stringvar cpt;

if not isnull({Authorization_ProcedureData.Code}) and {Authorization_ProcedureData.Code} <> '' Then
    if instr(cpt , ',' + {Authorization_ProcedureData.Code})=0 then
        cpt := cpt + ',' + {Authorization_ProcedureData.Code};

''

*****
I want to now see if it is possible to be able to add something to this report, to do this:

If {Authorization_ProcedureData.Code} in ['550','551','552','559','580','581','582','589']
Then 'G0300'
Else
If {Authorization_ProcedureData.Code} in ['420','421','422','424','429']
Then 'G0151'
Else
If {Authorization_ProcedureData.Code} in ['430','431','432','434','439']
Then 'G0152'
Else
If {Authorization_ProcedureData.Code} in ['441','442','444','449']
Then 'G0153'
Else
If {Authorization_ProcedureData.Code} in ['570','571','572','579']
Then 'G0156'
Else
If {Authorization_ProcedureData.Code} in ['560','561','562','569']
Then 'G0155'

******
Can this be done and if so how?

TIA

Always appreciate the help!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3678
Quote hilfy Replybullet Posted: 22 Jul 2020 at 10:01am
It's not clear where you want to add this. Is this a value to add this. Is this a value to add to the existing formula?

-Dell
IP IP Logged
BoltzGirl
Groupie
Groupie
Avatar

Joined: 22 Jan 2013
Online Status: Offline
Posts: 85
Quote BoltzGirl Replybullet Posted: 23 Jul 2020 at 1:09pm
I would like to add it to the existing formula(s) if that is where it will work.

The report is working off quite a few formulas that are related to the CPT Codes and I am not sure how to now add that when the report pulls in a CPT code of one of these CPT codes being used;
'550','551','552','559','580','581','582','589'

I want it to change that to G0300 every time.

The multiple formulas already on the report, I am not familiar with them and they are below, if that helps at all.

Formula is called: AllCPT and does this:
shared stringvar cpt;
mid(cpt,2)

Formula is called: AllCPTDescp and does this
shared stringvar cptdesc;
mid(cptdesc,2);

I just don't know how those formulas work and how to add my new need or where to add it in the report.

Thank you if any of this makes help and sense.

Always appreciate the help!
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.000 seconds.