Not exists condition 1

[BHScripter]

Hi:
I have a report that pulls additional rental charges such as pet rent and garage fee. each charge has a status of either being part of the renter's current lease or being part of a renewal proposal. Such as:

Charge type charge description amt
Current garage $50
Current pet rent $35
Renewal garage $65

Sometimes there are only current charges and no renewal charges. So the report only has charges that are tagged current charge type for a particular renter.

I currently have the report group based on renter then charge type. If I have a person that has no renewal charges, I want to put a "filler" in the renter group footer that subs for the Renewal charge type section to just say :
Renewal Charges:
N/A

I want to suppress in all instances where renewal charges exist for a person. I can't figure out how to code the suppression formula - it should always suppress if renewal charges are being returned for a particular renter.

Thanks in advance.

 

[IanWaterman]

Group by Person ID

In main toolbar select Report -> Selection Formula-> Group

in formula editor enter

Sum(renewalfee, personID) = 0

This will suppress all with a renewal fee.

For N/A use variables

@reset // place PersonId header suppress object so not visible
Whileprintingrecords;

global booleanvar renewfee:=false;

@eval//place details suppress object so not visible
Whileprintingrecords;

global booleanvar renewfee;

If {Charge type} = 'Renewal' then renewfee:= true

@display // place in person ID footer

Whileprintingrecords;

global booleanvar renewfee;

If renewfee = false then 'N/A' else totext(RenewalCharge)

Ian

 

[BHScripter]

Thank you that worked great!