[GNC] Reporting Tools

Klaus Dahlke kdahlke at gmx.de
Mon May 6 16:52:30 EDT 2019


Alternative is to use a database (mysql, postgres, SQLite) and e.g. libreoffice as GUI frontend for reporting/dataretrieval. Clearly, still some basic SQL know might be required.

Cheers,
Klaus

On Wed, 1 May 2019 00:57:50 -0500
Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:

> Unless you’re up for learning SQL, there is an easier path if all you want are pretty reports.
> 
> You can copy/paste reports to a spreadsheet and manipulate from there.
> 
> You can get part of the way to a ‘dashboard’ with the multi-column report. Look into it.
> 
> Otherwise, probably an intermediate step would be to use the SQlite backend paired with piecash for your report queries.
> 
> Maintaining and setting up a MySQL db is certainly more involved.
> 
> Regards,
> Adrien
> 
> > On Apr 30, 2019, at 11:07 PM, Sachin Danave <sachin.danave at gmail.com> wrote:
> > 
> > Hi All,
> > 
> > I am not a programmer and have been using MS Money for years. While I love
> > the Gnucash features, I miss the MS Money colorful reports (and yes a
> > beautiful dashboard).
> > 
> > I came across a post (I think it was Reddit) that suggests that you can
> > save Gnucash file to a MySQL database and then use an external
> > reporting tool to generate custom reports.
> > 
> > Has anyone tried this ? How difficult it is assuming no programming
> > knowledge ?
> > 
> > Thanks in advance
> > 
> > Best Regards
> > 
> > Sachin
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list