Report Calculations

[Joffies]

Hallo

Its been one of those days and i cant seem to get my head around this. Maybe someone can help me right.

I have a report that calculated transactions between two dates.

say for example between 05/04/2001 and 05/04/2002.

I have to calculate and opening balance for the above perdiod in other words a sum of all the transactions before 05/04/2001.

I then need to add the sum of all the transactions between the two dates and add or subtract it from the opening balance.

How would i go about in doing this in crystal report designer?

Many thanks

[manu487]

ok ... first u find the opening balance and insert the value into a formulae and place it in report header.
In report details u insert the present transactions. and fing its total.

Insert a new formulae and calculate u r balances like
{Formulae value in header}-{Transaction values} and place it into report footer. I think it will helps u.