[GNC] Reporting Tools

[Sachin Danave]

Sorry for the late reply

Have not been accessing my emails.

For now, I will keep my focus on the non-technical part :) and stick to the
Excel option ...

Thanks for the help

Sachin

On Tue, May 7, 2019 at 2:25 AM Klaus Dahlke <kdahlke at gmx.de> wrote:

> 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.
> _______________________________________________
> 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.
>