[GNC] Reporting Tools

[Adrien Monteleone]

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