sum of Non-Supressed Data

[idehen]

Hi People,

am using CR.10.

Problem:
I have a report where some data are supressed and some are not based on certain condition. e.G

Actual Data:

Customer Id Name Leave_Date Amount
Opening Balance 620.00

1 Joe 01/01/2003 50.00
2 Blogg 230.00
3 Jamie 40.00
4 Smith 23/12/2007 300.00

Closing Balance 0.00



Above is the actual data, however, in my report the data without leave_date are supressed and my opening balance is
is sum of all the Amount and
closing balance is (620 - 50 - 230 - 40 - 300 = 0.00).

Though the closing balance given that i only want to see leavers should be 620 - 50 - 300 = 270

How can i do this without so the report value only subtracts leaver amount and not just everyone.

Note i cannot use parameter to get leavers only cos i need the opening balance to show total sums for leavers or not hence why the supression.

Any suggested appreciated guys.

Thanks

 

[Madawc]

Create a Running Total using the same test. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Do a running total that sums the amount, evaluates using a formula:

not isnull({table.leavedate}) or
{table.leavedate} <> date(0,0,0)

Then subtract the running total from the beginning balance.

-LB

 

[idehen]

Thanks for that link Madawc and Ibass for the example.

Appreciate it.