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: Projects/Advanced/MigrateDRRProjectPortal