transaction report sorting

[Derek Atkins]

Hi,

Chris Bare <chris at ariescomputing.com> writes:

> In the transaction report, I picked date as my primary sort key and
> account name as my secondary sort key.
> What I wanted to do was see each account's transactions grouped by
> month, for the whole year.
> I think this is impossible because I'd really need to sort by month, but
> that's not an option.
> Can anyone think of a way to do this?

There is no way to group by month, short of running the report
multiple times, one for each month.

You also have the sort in the wrong order.  The output you have below
is correct for your sort order.  In particular, you are saying:

        primary:  sort by date.
        secondary: if there are multiple entries, further sort by account.

I think what you REALLY want is:

        primary: sort by account
        secondary: sort by date (so you see txns in order within an account)

and then limit the report to the month in question. 


Then you can run the report multiple times, one for each month.

> As I have it set up, I get multiple sections for some accounts if there
> are transactions in other accounts on intervening days, like this:
> 
> 01/02  acct1
> 01/03  acct1
> 
> 01/05  acct2
> 
> 01/07  acct1
> -- 
> Chris Bare
> chris at ariescomputing.com

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available