= Matrix Report Project = 

Create a generic method in the [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 | Townville |
| Helping Hands | Food Distribution | High Valley |
| Safer World | Water Supply | Townville |
| Safer World | Food Distribution | Newtown |

''Matrix View:''
| Helping Hands | Food Distribution | Townville |

== Current Implementation ==
Live on: http://demo.drrprojects.net/drrp/drrpp/project/matrix
Code in: 

== 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]