Reporting front-end

GhostlyPea · 29 Aug 2018 at 15:47

Hi all

I have a MySQL database that I'm looking to generate some reports out of. Ideally I want a PHP front end that allows for the designing, creating, generating and automating of basic reports from this set of data. If it can have some kind of UI that allows you to select drop down lists and select filters etc. that would be ideal, preferably with some sort of export to pdf/excel/html

Probably asking a lot especially as I need it to be free/opensource. Any ideas or recommendations?

- GP

SMN · 30 Aug 2018 at 10:32

JasperSoft? https://community.jaspersoft.com/project/jasperreports-server/releases

Not quite drag and drop but i've used this before and its not too shabby.

Your other option is to check if something like Kibana allows for plugging into MySQL?

Hades · 30 Aug 2018 at 13:32

I think LibreOffice Calc can connect to MySQL in a similar way that Excel can be used as a front end for databases.

GhostlyPea · 30 Aug 2018 at 15:25

Thanks for the replies both. Kibana I had a brief look at so will check that out again along with Jasper, thanks for the idea. If they ""fail"" for me then falling back to Excel/Libreoffice integration may be all I can do

Appreciate the input guys

- GP

SMN · 3 Sep 2018 at 13:49

One other thought; Splunk Free?

GhostlyPea · 3 Sep 2018 at 14:12

Not sure Splunk will work too well. The sort of data were looking at here is from an IPAM database so were looking at devices, status, IPs, locations, circuits etc. most of the reporting will simply be returning lists of information based on filters rather than compiling numerical data. The idea of a front end simply means its easier for me to use than trying to stitch tables together using drop downs on a web page to export things like "all sites with XXX ISP and XXX type of firewall". To be fair Excel may well be the best option but i just need to see if theres anything fancier out there thats client less. Appreciate the ideas though

- GP