How to create a list view like a spreadsheet

[CCBtx]

I have a table that has transactions for a number of different entities.

I am displaying the transactions on a report sorted by date and entity.

Each record has an amount and ending balance.

Is there a way to bring the ending balance down from the prior row (like you do in a spreadsheet)?

...I know that I can programatically scroll through and do the math.

...I also know that I can subtract the amount from the ending balance.

What I want to do is just "grab" the prior sorted record's ending balance in the list view.

[comment]

Well, you could use the GetNthRecord() function - but I believe this will be slower than just subtracting within the record.

[CCBtx]

Thanks a lot... and all before they shut the door on my aircraft. (sometimes I dont have the ending balance).

This helps

CCB

[comment]

sometimes I dont have the ending balance

Why not use a running total summary field?

[CCBtx]

That is an interesting thought.

I achieve the ending balance with a running total summary field.

The point is that if I start in the middle of a date range... or the found set for that matter, I have to find a beginning balance to get the ending balance. Of course the ending balance works perfectly if I start with, say, -0-, but if I pull my report for any time interval other than the total, I need a beginning balance.

That is what I am struggling with.

[comment]

It depends on what exactly you are dealing with. For example, if you do know the starting balance, you could put it in a global and add it to the running total. Another option is to lookup the previous balance when a new record is created (assuming records are created in chronological order).