1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Reporting front-end

Discussion in 'Linux & Open Source' started by GhostlyPea, Aug 29, 2018.

  1. GhostlyPea

    Mobster

    Joined: Dec 30, 2004

    Posts: 4,557

    Location: Beckenham, Kent

    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
     
  2. SMN

    Wise Guy

    Joined: Nov 2, 2008

    Posts: 2,384

    Location: The ether

  3. Hades

    Capodecina

    Joined: Oct 19, 2002

    Posts: 20,362

    Location: Surrey and London

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

    Mobster

    Joined: Dec 30, 2004

    Posts: 4,557

    Location: Beckenham, Kent

    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
     
  5. SMN

    Wise Guy

    Joined: Nov 2, 2008

    Posts: 2,384

    Location: The ether

    One other thought; Splunk Free?
     
  6. GhostlyPea

    Mobster

    Joined: Dec 30, 2004

    Posts: 4,557

    Location: Beckenham, Kent

    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