Reports, probably again

[James Wilde]

It has to be said: gnucash is a great product for inputting data, but the native reporting system sucks.  Html is _not_ the correct format for printed reports and the default font, Arial or Lucida, or whatever it is, is also wrong for business reports.  Additionally I have changed the default font to Courier in Settings, but I can't see that it has affected my reports in any way.

Cutting and pasting into LibreOffice calc and reformatting there is also a messy business, and printing to a html file and opening that in calc is no better.  Unfortunately I don't have the programming know-how or I would set about creating a proper gui-based reporting system for Gnucash.  And why are so many fields clickable links?  None of them appear to lead anywhere.  Well, they do when the report is open in Gnucash, of course, but the link nature is carried over to the report document, and there it has absolutely no value except to print account names and transaction values in blue, underlined and clickable.

Is anyone using the option in later versions to use a sql backend?  In that case, is it possible to connect a decent sql report generator to the backend and produce acceptable business reports?  If so, and you could provide a few tips for newbies to get us up and running, it would be very much appreciated.

TIA

James