wiki:BluePrint/Reporting

Version 17 (modified by Fran Boon, 12 years ago) ( diff )

jqPlot

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), we can use Geraldo.
We have made use of this for the PDF representation of the REST Controller (via ReportLab). It also supports Graphics (via PIL):

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.