How to do this: IF statement?

[bloomlight]

I have to make a crystal report with data if field A matches first 2 letters of field B. This is what I want to do:

field A: field B
========= ========
PT PTNB
PT
PTNN
PTEV
PTS
SW SWS
SWN
HH HH

For SQL coding, I can make a query similar to this: field B like 'PT%'. But don't know how to set up in Crystal. Any suggestions? Thanks.

 

[kray4660]

You can create a formula that does a Left({field B} , 2) and group on that formula. Likewise, if not all your field A's have a matching field B, then you could filter by your report with the statement '{field A} = Left({field B}, 2).

I hope this helps.

 

[bloomlight]

It worked. Thanks you so much!!!!

 

[bloomlight]

Another question: How to filter out some of the names in field B?

for example, I want all above listed except "PTNB" and "PTNN". How can I do that?

Thanks.

 

[fisheromacse]

in the 'grouping' formula you already have from kray, add a check to exclude the unwanted values:

IF ({Field B} in ["PTNB", "PTNN"])
THEN ""
ELSE Left({field B} , 2)

 

[bloomlight]

I coded the following, but got error message saying that "A boolean is required here". What was wrong? Thanks.

IF Left({ServiceType}, 2) = {DiciplineID} and {{ServiceType} in ["PTNB", "SNNB", "SD"]}
THEN ""
ELSE Left({ServiceType}, 2)

 

[fisheromacse]

you have {} instead of () around this {ServiceType} in ["PTNB", "SNNB", "SD"]



you could also add parenthesis to ensure clear logic:

IF ((Left({ServiceType}, 2) = {DiciplineID}) and ({ServiceType} in ["PTNB", "SNNB", "SD"]))
THEN ""
ELSE Left({ServiceType}, 2)