wiki:BluePrint/Reporting

Version 20 (modified by Fran Boon, 12 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), 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):

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

Note: See TracWiki for help on using the wiki.