Friday, October 3, 2008
Evaluating GnuCash in Ooo
This blog is dedicated to the discussion of my macro "gnuc2ooo".
If you haven't done so already please read at least the introduction before posting.
Aside from general comments you can leave feature requests, examples for application you want to share and bug reports.
If possible leave some detail on your Operating System, e.g. "Windows XP" or even something like "Linux ubuntu 8.04, GnuCash 2.24, OpenOffice.org 2.4.1", but this is optional.
If you haven't done so already please read at least the introduction before posting.
Aside from general comments you can leave feature requests, examples for application you want to share and bug reports.
If possible leave some detail on your Operating System, e.g. "Windows XP" or even something like "Linux ubuntu 8.04, GnuCash 2.24, OpenOffice.org 2.4.1", but this is optional.
Labels: General discussion
Thursday, October 2, 2008
Variants of reports
One of my helpful testers (thank you, Michael!) with a big GnuCash file over several years accomplished good results with the following query in Ooo-Base which he then evaluated by the DataPilot in Calc:
SELECT "ACCOUNT-TYPE", "LEVEL2", SUBSTRING ( "DATE_YM" FROM 1 FOR 4 ) AS "DATE_Y", SUM( "VALUE" ) AS "VALUE"
FROM "ALL_TRANSACTIONS"
GROUP BY "ACCOUNT-TYPE", "LEVEL2", "DATE_Y"
With "LEVEL2" instead of "ACCOUNT-NAME" he condenses somewhat the accounts and by isolating the first 4 characters from "DATE_YM" he will have the years instead of the months as columns, altogether a wonderful general overview over the whole file.
SELECT "ACCOUNT-TYPE", "LEVEL2", SUBSTRING ( "DATE_YM" FROM 1 FOR 4 ) AS "DATE_Y", SUM( "VALUE" ) AS "VALUE"
FROM "ALL_TRANSACTIONS"
GROUP BY "ACCOUNT-TYPE", "LEVEL2", "DATE_Y"
With "LEVEL2" instead of "ACCOUNT-NAME" he condenses somewhat the accounts and by isolating the first 4 characters from "DATE_YM" he will have the years instead of the months as columns, altogether a wonderful general overview over the whole file.
Labels: Variants of reports
