Monthly Income/Expense Reports

[Martin Cunningham]

Ah - got it. Thank you!

Is anyone posting SQL statements they have used to generate reports? seems a
repository of those would be a useful thing.

Martin Cunningham


On Sat, Jul 17, 2010 at 3:34 AM, Geert Janssens
<janssens-geert at telenet.be>wrote:

> On Friday 16 July 2010, Martin Cunningham wrote:
> > Well I found an answer to one of my questions: the schema is posted
> > here<http://wiki.gnucash.org/wiki/SQL>.
> > I have downloaded/installed a copy of MySQL and the 'Workbench' GUI. Now
> > what - can someone tell me how to connect to the GnuCash data source?
> >
> > Martin Cunningham
> >
> Did you save your gnucash data into a mysql database already ?
>
> You can do so by opening your existing data file and use "Save as"
> to save it in mysql.
>
> From there on, you should be able to simply run your mysql queries in any
> mysql aware tool (like MySQL workbench).
>
> Geert
>