cannot find report

[Christopher Lam]

Don't think so, not for transactional level reporting. Perhaps you can use
an external tool to do complex SQL queries. The transaction report,
designed a long time ago, cannot be easily transformed to achieve
multilevel subtotals, nor subtotals on account parents.

If you don't need the transactional data you can use the Income Statement
for Multi level subtotals.


On 26 Oct 2017 00:05, "Paul de Vries" <paul.de.vries at xs4all.nl> wrote:

> *From: *Paul de Vries <paul.de.vries at xs4all.nl>
> *Sent: *Wednesday, 25 October 2017 10:07 PM
> *To: *gnucash-user at gnucash.org
> *Subject: *cannot find report
>
> I need a transaction report for a given period with total over
> sub-accounts, e.g.
>
> 999 main account
>               21 oct transaction $ 1.00
> 999 total for apr $ 1.00
> 999-1 sub account
>               22 oct transaction $ 2.00
> 999-1 total for apr $ 2.00
> total for main + sub account $ 3.00 <-- this is the line i'm looking for.
>
> i remember vagely that i did something like this in the past but i cannot
> find it anymore.
>
>
>
> On 25 Oct 2017, at 17:12, Christopher Lam <christopher.lck at gmail.com>
> wrote:
>
> You can run the standard Transaction Report, choose options:
> Accounts/Accounts: click a parent account, click “Select Children”;
> ***don’t select any other accounts***
> Sorting/Primary Key: account name
> Sorting/Primary Subtotal: true
> Sorting/Secondary Key: none
> This will give you the total for parent + subaccounts.
>
> I don’t think there’s a facility to report on multiple levels of subtotals.
>
> Alternatively you can try: from the main account register, select the
> parent account, Edit>Open Subaccounts
> Then run Report>Account Report. This will give a running balance. But I’m
> not 100% sure this is meaningful.
>
> C
>
>
> thanks. this can only work for a single account where the bottom total is
> for the main + sub accounts.
> is something like this not possible for multiple accounts with
> sub-accounts, separate totals per main account?
>