I guess I'm just going to resign myself to the fact that what I want isn't possible. (Summary of account balances (by account) with a cutoff date, without needi...

If I only have columns for Account and Amount, I get all the detail. If I remove the account leaving only the Amount column, the report errors out.

Additionally - I'm not sure this error is temporary. It may be erroring because I'm grouping by account, but not including an account column on the report. The ...

Thank you for your reply, it makes sense that it would accomplish what I need, except for the grand total of all accounts and I'm willing to live without that (...

Thank you for the helpful and detailed suggestion. A couple follow up questions trying to get to my "perfect" solution on this:1- Based on your suggestion to ex...