wiki:Projects/Advanced/MatrixReport

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

--

Matrix Report Project

Create a generic method in the 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:

Also see: Projects/Advanced/MigrateDRRProjectPortal

Note: See TracWiki for help on using the wiki.