wiki:BluePrint/Reporting

Version 26 (modified by Fran Boon, 11 years ago) ( diff )

--

Blueprint for Reporting/Charting

We need to be able to generate Pretty & Informative Reports from the database.

For quick visualisations in the browser, we have included jqPlot.

For more formal reports (which can also be retrieved via webservices using the PDF representation of the REST Controller), we currently use ReportLab via Geraldo. This also supports Graphics (via PIL)

Other options:

Excel files are currently written using xlwt. Other options:

T2 includes a basic barchart function:

def barchart(data,width=400,height=15,scale=None,
             label_width=50,values_width=50):
    if not scale: scale=max([m for n,c,m in data])
    if not scale: return None
    return TABLE(_class='barchart',
           *[TR(TD(n,_width=label_width,_style="text-align: right"),
           TABLE(TR(TD(_width=int(m*width/scale),_height=height,
           _style='background-color:'+c))),TD(m,_width=values_width),
           _style="vertical-alignment: middle") for n,c,m in data])

Could be something to use Flash? (although best-avoided, if possible, to minimise client support)

S2 version:


BluePrints BluePrints

Note: See TracWiki for help on using the wiki.