Changes between Version 27 and Version 28 of BluePrint/Reporting


Ignore:
Timestamp:
08/30/10 09:01:34 (11 years ago)
Author:
Fran Boon
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • BluePrint/Reporting

    v27 v28  
     1[[TOC]]
    12= Blueprint for Reporting/Charting =
    23
    34We need to be able to generate Pretty & Informative Reports from the database.
    45
     6e.g. BluePrintImpact
     7
     8== Charts ==
    59For quick visualisations in the browser, we have included [http://www.jqplot.com jqPlot].
    610
    7 For more formal reports (which can also be retrieved via webservices using the PDF representation of the REST Controller), we currently use [http://reportlab.org ReportLab] via [http://geraldo.sourceforge.net Geraldo]. This also supports Graphics (via [http://www.pythonware.com/products/pil/ PIL])
    8 
    9 Other options:
    10  * http://www.reynoldsftw.com/2009/02/6-jquery-chart-plugins-reviewed/
    11   * Recommends [http://code.google.com/p/flot/ Flot]: "''From an interaction perspective, Flot by far will get you as close as possible to Flash graphing as you can get with jQuery.''"
    12  * [http://www.xhtml2pdf.com Pisa] uses [http://reportlab.org ReportLab] to generate PDF from HTML
    13  * [http://code.google.com/p/jspdf jsPDF] uses pure !JavaScript to create PDFs
    14  * Use S3XRC & hence XSLT to generate XML-FO which can be converted to PDF
    15   * http://xmlgraphics.apache.org/fop/
    16   * http://pypi.python.org/pypi/zopyx.convert/
    17   * [http://osdir.com/ml/python.reportlab.user/2003-10/msg00206.html Recommend ReportLab over FOP]
    18 
    19  * [http://matplotlib.sourceforge.net/faq/howto_faq.html#matplotlib-in-a-web-application-server Matplotlib] can generate visualisations
    20  * [http://www.web2pyslices.com/main/slices/take_slice/12 Cairo] can generate nice charts from the back-end
    21  * [http://appyframework.org/pod.html Pod] to create Open Document Format
    22 
    23 Excel files are currently written using [http://pypi.python.org/pypi/xlwt xlwt]. Other options:
    24  * [http://sourceforge.net/projects/pyexcelerator PyExcelerator]
    25  * Docs on Python Excel libraries: http://www.python-excel.org/
    26  * Thread recommending xlwt: http://groups.google.com/group/web2py/browse_thread/thread/375307e92df40ca8
     11We have included the [http://healthscapes.org Healthscapes] SaVaGe library to easily output SVG graphs:
     12 * http://eden.sahanafoundation.org/browser/modules/hs/graph
     13 * We should have a recommended tested SVG plugin for Internet Explorer < 9
    2714
    2815T2 includes a basic barchart function:
     
    3926}}}
    4027
     28 * [http://matplotlib.sourceforge.net/faq/howto_faq.html#matplotlib-in-a-web-application-server Matplotlib] can generate visualisations
     29 * [http://www.web2pyslices.com/main/slices/take_slice/12 Cairo] can generate nice charts from the back-end
     30
     31== PDF ==
     32For more formal reports (which can also be retrieved via webservices using the PDF representation of the REST Controller), we currently use [http://reportlab.org ReportLab] via [http://geraldo.sourceforge.net Geraldo]. This also supports Graphics (via [http://www.pythonware.com/products/pil/ PIL])
     33
     34Other options:
     35 * http://www.reynoldsftw.com/2009/02/6-jquery-chart-plugins-reviewed/
     36  * Recommends [http://code.google.com/p/flot/ Flot]: "''From an interaction perspective, Flot by far will get you as close as possible to Flash graphing as you can get with jQuery.''"
     37 * [http://www.xhtml2pdf.com Pisa] uses [http://reportlab.org ReportLab] to generate PDF from HTML
     38 * [http://code.google.com/p/jspdf jsPDF] uses pure !JavaScript to create PDFs
     39 * Use S3XRC & hence XSLT to generate XML-FO which can be converted to PDF
     40  * http://xmlgraphics.apache.org/fop/
     41  * http://pypi.python.org/pypi/zopyx.convert/
     42  * [http://osdir.com/ml/python.reportlab.user/2003-10/msg00206.html Recommend ReportLab over FOP]
     43
     44== Spreadsheets ==
     45Excel files are currently written using [http://pypi.python.org/pypi/xlwt xlwt]. Other options:
     46 * [http://sourceforge.net/projects/pyexcelerator PyExcelerator]
     47 * Docs on Python Excel libraries: http://www.python-excel.org/
     48 * Thread recommending xlwt: http://groups.google.com/group/web2py/browse_thread/thread/375307e92df40ca8
     49
     50 * [http://appyframework.org/pod.html Pod] to create Open Document Format
     51
     52== Flash ==
    4153Could be something to use Flash? (although best-avoided, if possible, to minimise client support)
    4254 * PyAMF: http://pyamf.org
     
    4759  * from Python: http://code.google.com/p/open-flash-chart-python/
    4860
    49 S2 version:
     61== Relevant Links ==
     62Phase2 version:
    5063 * http://wiki.sahanafoundation.org/doku.php?id=dev:reportinglib
    5164