Totalling Balance (Reverse Running Total)

[Rodders]

Hi Guys,

I am fairly new to Crystal Reports, So I am trying to build my knowledge as much as possible!!

I cannot think of a way that I can do this, I wonder if anyone can help?

So I am creating a Rents report to show Resident Transactions, Residents can have a Credit or a Debit against their name, for two categories; Personal (Credit & Debit) & Benefit (Credit & Debit). I am displaying this information as per transactaction, grouped by person. Now what I need are 3 more fields:

Personal Total Balance
Benefit Total Balance
Total Total Balance

All fields should update after each transaction.

This sounds easy enough, but I need it in Date Descending Order (So that the latest is at the top), to my knowledge, Crystal only works from top-down, is there any way I can work from bottom-up!??

I hope this makes sense, If you need any more info, please ask!

Looking forward for some help!!

Thanks
Rod

p.s. Like the forum!

[jggtz]

If You have access to the source of the application then write a procedure that make all the operations over the table before calling the report

[Rodders]

Hi,

Yes I have access to the source, I am looking at writing a Stored Procedure, which uses a Temporary table to calculate the required fields. I'm getting there, still very new to all this though!! Fortunately, I have a colleague to help!

I was just wondering whether Crystal could make life easier for me.

Thanks for your help