RSR KPI publishing

[zzgvh]

To start using ReportServer (RS) "for real" we'd like to publish KPI-like data from RSR to akvo.org. Lynn has made a bunch of initial work on this and based on this I have started to create dynamic list reports in RS.

Currently we have reports showing cumulative data per month for

• number of updates
• number of RSR projects
• number of partners
• Projects and organisation combo
• total budget in € and $

Rough plan:

• Improve the current set of graphs, there are some kinks to work out with the date display
• Figure out how to publish those graphs. RS allows easy setup of links to a chart, but ideally I'd like to use the SVG source rather than an iframe. Needs investigating.
• Figure out how much customization of the graphs we can accomplish "easily". Out of the box there's very little that can be done in terms of formatting on the RS side and I expect Gabe and Loic wanting to tweak things :wink:
• Ask our UI/UX team for a design of a page that'll probably live under /seeithappen.

A possible interim solution is to create a dashboard in RS. I think you have to be logged in to access dashboards however, so it's not ideal.

[zzgvh]

In addition to charts the data could be shown in grid format too. With links to download the data.