= Matrix Report Project = 

Create a generic method in the [wiki:S3XRC/RESTfulAPI/s3_rest_controller REST Controller] which could produce a ''"Matrix"'' or ''"Cross-Tab"'' style report.

== Example ==
''List View:''

|| '''Organisation''' || '''Activity''' || '''Location''' ||
|| Red Cross || Water Supply || Townville ||
|| Red Cross || Food Distribution || Townville ||
|| Red Cross || Shelter || Townville ||
|| Helping Hands || Food Distribution || Newtown ||
|| Helping Hands || Food Distribution || High Valley ||
|| Safer World || Water Supply || Townville ||
|| Safer World || Food Distribution || Newtown ||

''Matrix View:''
||               ||'''High Valley''' || '''Newtown''' || '''Townville''' || 
|| '''Food Distribution''' || Helping Hands, Helping Hands  || || Red Cross ||
|| '''Shelter''' || || || Red Cross  || 
|| '''Water Supply''' || || Safer World  ||Red Cross, Safer World  ||


== Current Implementation ==
Live on: http://demo.drrprojects.net/drrp/drrpp/project/matrix[[BR]]

Code in: http://bazaar.launchpad.net/~michael-howden/sahana-eden/adpc/view/head:/models/drrpp.py see: line 2668 - def shn_drrpp_matrix(xrequest, **attr):


== Features ==
 * Customisable for different resources.
  * Choose which fields can be the rows / columns.
  * Chose which field will fill the cells.
  * Ability to use months (from a date field).
  * Ability to use different location hierarchies.
 * Possibility to show either a count or a list (perhaps using JS to switch between them?)
 * Export to PDF, XLS & XML

== Potential Methods to Implement ==
Some methods which could be worth exploring:
 * http://docs.python.org/library/xml.etree.elementtree.html
 * Using an XSLT

''Also see:'' [wiki:Projects/Advanced/MigrateDRRProjectPortal]