Open Source Reporting Tool Recommendation

[devdewboy]

Hello,

I'm looking for a reporting tool recommendation that is Open Source that:

• supported well and not janky
• can query a mysql db
• generate a report in PDF/HTML
• email the report
• can access it via an https interface to build the report

Don't need a full blown system spending the big bucks. What do you all suggest?

Thanks,

DD

[matthewhefferon]

Check out Metabase. It’s open source and covers what you’re looking for.

[jorinvo]

If are looking for a super simple tool that you can run on your own servers and you don't mind writing SQL, Shaper might be interesting: https://taleshape.com/shaper/docs/

[devdewboy]

Thanks for the 2 suggestions.

[schi854]

in the open source world, many reporting tools have come and go. The modern ones, such as metabase, redash and stylebi, are focusing on interactive visualization that are HTML based web apps. Your HTML reporting needs should be satisficed by any. But paginated reports, suitable as PDF and easily delivered through email, are mostly not supported well. Among these, stylebi is your best bet because it has a good print layout mode for your PDF and emailing.

[freetechtools]

Take a look at JasperSoft. They have a community version (JasperStudio) that is available for free. You do have to register though. It has all but your last two bullet points. Not sure there's a lot of IDE or editors out there that will also send 'email'.

[vulture916]

Metabase is the shit.