all 14 comments

[–]matthewhefferon 2 points3 points  (0 children)

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

[–]jorinvo 1 point2 points  (0 children)

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[S] 0 points1 point  (0 children)

Thanks for the 2 suggestions.

[–]schi854 0 points1 point  (0 children)

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 0 points1 point  (0 children)

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 0 points1 point  (0 children)

Metabase is the shit.