wiki:Projects/Advanced/MatrixReport

Version 1 (modified by Michael Howden, 10 years ago) ( diff )

--

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:

Also see: Projects/Advanced/MigrateDRRProjectPortal

Note: See TracWiki for help on using the wiki.