How do you omit records based on previous records

[TanmedIT]

I have a report that is based on transactions of our product.. When a customer purchases a product our accounting software puts a -1 in the transaction amount.. If the product is returned, it gets a +1.

My question is how can I omit those records that have been returned. I have tried to suppress if the trans amt is not -1, but that leaves the original record for those that have been returned. I only want to have those that are still with the customers

 

[kenhamady]

You are trying to add a condition that involves more than one record, which is called group selection in Crystal.

Insert a Group so that the two records are in the same group, subtotal the qty so that you get a net of 0 for that group, and then you can select only groups that have a subtotal <> 0.

Keep in mind that these records will not print, but will be included in counts and sums unless you use running totals. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[TanmedIT]

Thanks!! It worked!!