suppress negitive amounts

[mtorpy]

I am working with Crystal Reports 8.5 doing some invoices that have a record with negative amounts that I do not want showing up on the report. That is easy to suppress the negative amounts.....but I want to also remove the corresponding record that has the same amount and date associated with it. Is there any formula's for searching for the corresponding transaction and possible removing it?

 

[dgillz]

Rather than supressing the data, have you tried using a record selection formula to exclude it from the report (and the totals) entirely? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[mtorpy]

I think that would be a great option, I am sure I could exclude the negative records, but how would I write somthing to remove its counter transaction? For example the negative entries are removing a transaction from the accounting system.

1.Mike was inputed for 8hrs of OT at 20.00per hour on 4-6-02

This is then backed out:

2.Mike was inputed for -8hrs of OT at 20.00per hour on 4-6-02


Then the proper enty is entered:

3.Mike was inputed for 5hrs of OT at 20.00per hour on 4-6-02

Transaction number one and two both need to be excluded from the report, but have no relation other then the date and absolute amount. Any ideas?

 

[dgillz]

OK now I get it.

Subtotal by date within employee, then write a group selection formula to get rid of the records that net to zero as follows:

Sum({Hours},{DateWithinEmployeeGroup})<>0

Let me know if you have any questions Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com