I attached the following formula to the first one:

 

global stringvar sPhysician:= sPhysician & {GetDataFromEDIClaims.ReferringProvider} & " - " & {GetDataFromEDIClaims.Modality} & ","

 

To the second I attached the following:

 

EvaluateAfter ({@Physician});
if totext({GetDataFromEDIClaims.ReferringProvider} & " - " & {GetDataFromEDIClaims.Modality}) in global stringvar sPhysician
then ""
else ({GetDataFromEDIClaims.ReferringProvider} & " - " & {GetDataFromEDIClaims.Modality})

 

The idea is that if sPhysician contains the Physician already, display a blank line otherwise display the physicin's name etc. Am I using the correct syntax or call to sort i.e. "in". Does this make senese?

 

You need two formulas: You can name them whatever, but for the sake of this post, I will name them AmountField and StringVarField.

Create them both before adding anything to them. Then, for the StringVarField, put in the first formula:

evaluateafter({@AmountField});

global stringvar sAmount:=sAmount & totext({table.amountfield}) & ', ';


Then add the next formula in AmountField:

if totext({table.amountfield}) in global stringvar sAmount
     then ""
          else totext({table.amountfield})

 

I don't use 'in' except when dealing with arrays, so totext(xxx + '-' + yyy) in zzz didn't make sense to me. if xxx or yyy were numbers, I believe that this would fail (can't add numbers like strings.  Also, typically totext adds decimals and commas unless told not to (at least for numbers, dates are different)

 

so I replied that instr(zzz, xxx + '-' + yyy) > 0 should work better...it's been my experience that if your code doesn't work, you look for possible solutions, which is someone else's code.

 

Alas, we're not always correct, or there is some other twist that we are unaware of.

 

as for debugging, have you tried:

after evaluate (sPhysician)

global stringvar sPhysician;

sPhysician

 

just to check that the values that you think are in the string are actually there?  debugging CR can be tough as it is a black box.  You are pretty sure about what goes in, and you are positive about what comes out, but you can't see what CR is doing or how it is working, so sometimes you have figure out how to 'see' what CR is doing and compare that to what you thought CR was doing.

 

HTH