wiki:BluePrint/Reporting

Version 18 (modified by Praneeth Bodduluri, 12 years ago) ( diff )

Added matplotlib

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):

We can also use Matplotlib for generation of visualisations:

http://matplotlib.sourceforge.net/faq/howto_faq.html#matplotlib-in-a-web-application-server

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.