Jump to content

How to create a list view like a spreadsheet


CCBtx
 Share

This topic is 4389 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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).

Link to comment
Share on other sites

This topic is 4389 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.