Want a web/html 'report writer' for sqlite3 databases

Chris G cl at isbd.net
Sun Oct 16 10:10:56 UTC 2011


I am looking for a way to display information from an sqlite3 database   
on web pages in the sort of way that a 'report generator' provides.

I.e. I want to be able to have breaks and indents in the report with
sub-headings etc. with the breaks being set by changes in the data.

For example I might have weekly timesheet information and I want it
output with weekly and/or monthly sub-totals:-

    Week 1
    ------

    Day         Job             Hours
    Monday      ABC             1.5
                XYZ             6.5
    Tuesday     ABC             8
    Wednesday   XYZ             8
    Thursday    AAA             7
                XYZ             1
    Friday      ABC             6

                                38
    (Maybe the totals for ABC, XYZ, etc. here too)


    Week 2
    ------


... and so on.  It's pretty standard report writer stuff but I can't
find anything that does it for web output.  There are full blown
application frameworks that can maybe do it but they are rather lower
level than I want as the database already exists and is created by other
tools.  I just want a configurable report writer.  Open Office can do
some of what I want but it's clumsy with sqlite3 and I'm not sure if it 
can produce an HTML version of the report.

-- 
Chris Green




More information about the ubuntu-users mailing list