Repeating Records

[donnarenia]

I am using version 9.2. I have attached a copy of my report

Problem….The items highlighted in yellow are invoices that show the Actual Amount billed for the client. The number in blue is the Final bill amount that I want to show. However on accounts that have additional invoices (SM CENTER FORT WORTH) it totals those invoices but then they are repeated on another entity (MOON GOLF PROPERTIES). This is happening because the billing engagement is associated with several invoices.

Question: Is there a formula I could write that could avoid the duplication and not inflate my Total Amount Billed per group? The billing Engagement is located in the Client Table the actual amounts are created in a sub report from the AR table.

 

[Madawc]

If you group by Billing Engagement, then you could total at that level, using a running total. Or you might do it with a running total that only totals for particular record types.

The use of Crystal's automated totals is outlined at FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP