if statement in a record selection Formula? 1

[willz99ta]

Hi and thanks,

I have a multiple line selection formula and I need to have an if statement in it if possible.

When I try:
{APINVOICE.REC_STATUS} = 9 and //<-- this works fine
if {APINVOICE.HAND_CODE} = "PO" then {APINVOICE.MATCH_FL} = "Y"

it will only pull data where ({APINVOICE.HAND_CODE} = "PO") when I don't want only that information.

Any ideas?

Thanks,
Will

 

[chelseatech]

You just need to write it as a valid boolean. I suspect the formula you want is...

{APINVOICE.REC_STATUS} = 9 and
{APINVOICE.HAND_CODE} = "PO" and
{APINVOICE.MATCH_FL} = "Y"

Just need to decide what the criteria is if {APINVOICE.HAND_CODE} <> "PO"

You have three fields involved. What values are included in the report, and what is excluded.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[willz99ta]

Can I write a separate query in the same report for {APINVOICE.HAND_CODE} <> "PO"?

 

[lbass]

I think you should set it up like this:

{APINVOICE.REC_STATUS} = 9 and
(
(
{APINVOICE.HAND_CODE} = "PO" and
{APINVOICE.MATCH_FL} = "Y"
) or
{APINVOICE.HAND_CODE} <> "PO"
)

-LB

 

[willz99ta]

Perfect LBass. That is exactly what I was trying to do.

Wo;;