Selecting data where flag is not"Y"

[koolskins]

I am running CR10 against an Informix database and am in need of printing purchase orders that did not have an invoice paid against them that was flagged as FINAL PAID. I have a PO file and an A/P file with a one to many relationship between the two. One or more of the a/p records against a given po may have a Y in the final_paid column and if any a/p record has a "Y", then I DO NOT want to print that po number. Any help would be much appreciated.

Thanks.
Randy

 

[MrBillSC]

You will need to do your reporting in the PO group footer.
In the detail section place a formula:
// formula {@IsClosed}
If {ApFile.final_paid} = "Y" then 1 else 0

Place your po data in the po group footer.
conditionally suppress the po footer section:
Sum({@IsClosed},PO_Num}) > 0

MrBill

 

[koolskins]

Thanks MrBill, worked like a charm.