Don't display if balance is zero 1

[mjbosko]

Say I have a report with a group on Customer and some detail records. The Cust group footer has a total. if that total is zero, I'd like to just omit the whole customer from the report.

Customer: JMT Systems

Date Invoice Type Amount
---------- --------- ----- -----------
12/13/2002 000131 Invc 3.50
12/15/2002 000131 Pmt (3.50)
-----------
Balance: $0.00

Customer: InfoSystems, Inc.

Date Invoice Type Amount
---------- --------- ----- -----------
1/3/2002 000132 Invc 5.50
1/6/2002 000135 Pmt (3.50)
-----------
Balance: $2.00

In this case, I wouldn't want to show the info for customer JMT Systems, but would for InfoSystems, Inc.

Having this done the recordset is not an option. Can it be done in the report?

Mike

 

[goranm]

Hi !

You can use a Group selection formula where you write:

Sum ({YourTable.Amount}, {YourTable.CustomerId}) > 0

(in the formula editor you just double click on the Summary field to get the wright syntax)

/Goran

 

[mjbosko]

EXCELLENT. Thanks, that took care of it, as well as your reply to my other post. Thank you.

Its been a bit of a struggle getting to learn CR after having been away from it for several years, but I must say, there has been nothing that I haven't been able to do!

Thanks for your help.

Mike