Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Reports for results framework #1831

Closed
KasperBrandt opened this issue Oct 1, 2015 · 3 comments
Closed

Reports for results framework #1831

KasperBrandt opened this issue Oct 1, 2015 · 3 comments
Assignees
@KasperBrandt
Labels
Type: Results framework
Milestone
3.8 Lilongwe

Comments

@KasperBrandt
Copy link
Contributor

Using ReportServer, we should be able to create a PDF version for the results framework.
@KasperBrandt KasperBrandt added this to the 3.8 Lilongwe milestone Oct 1, 2015
@stellanl
Copy link
Contributor

stellanl commented Oct 5, 2015

My understanding so far:

A BIRT report for a single project, with results, indicators and periods, formatted along the lines of the PPP_Report_2014_2015.05.21_final.pdf

Parameters would be

  • Project ID
  • Time span? (Including only the indicator periods that fall within it.)

stellanl added a commit that referenced this issue Oct 20, 2015
@stellanl
[#1831]First version of single-project report
87f07d1
stellanl added a commit that referenced this issue Oct 20, 2015
@stellanl
[#1831]First version of single-project report, all files
ee7354a
stellanl added a commit that referenced this issue Oct 20, 2015
@stellanl
[#1831]Use report parameter for all data sets. Add dials.
0b413ce
stellanl added a commit that referenced this issue Oct 22, 2015
@stellanl
[#1831]Add child project table. Hide empty tables.
66a399e
stellanl added a commit that referenced this issue Oct 22, 2015
@stellanl
[#1831]Add parent project(s) table.
72cad24
stellanl added a commit that referenced this issue Oct 22, 2015
@stellanl
[#1831]Add deployment information to the readme.
3c9fd59
stellanl added a commit that referenced this issue Oct 23, 2015
@stellanl
[#1831]Add project time span. Handle missing city.
71e0abf
@stellanl
Copy link
Contributor

The Result section is now hidden if totally empty, but looks weird for a project that has Results but no Indicators or Periods: the periods etc are output as (null) fields.

stellanl added a commit that referenced this issue Oct 23, 2015
@stellanl
[#1831]Hide indicators and periods if none in database.
ac0d50d
@stellanl
Copy link
Contributor

Selecting * for a dataset with a join creates aliases for duplicated names (such as id) like id_9 and id_28. If the table is later changed (such as adding more columns) these aliases will change and break a report that relies on them.

stellanl added a commit that referenced this issue Oct 26, 2015
@stellanl
[#1831]Use explicit column nams in result select. Improve graphical l…
398e6b3 
…ayout.
stellanl added a commit that referenced this issue Oct 26, 2015
@stellanl
[#1831]Improve graphical layout.
25506f5
stellanl added a commit that referenced this issue Oct 26, 2015
@stellanl
[#1831]Hide indicator footer if no indicators.
3228899
stellanl added a commit that referenced this issue Oct 26, 2015
@stellanl
[#1831]More sedate colors.
933ea46
stellanl added a commit that referenced this issue Oct 27, 2015
@stellanl
[#1831]Adapt colours to model pdf. Change dials to doughnut charts, s…
fcd5ed2 
…uperimposed w text percentage.
stellanl added a commit that referenced this issue Oct 27, 2015
@stellanl
[#1831]Cap dial percentages at 100. Restyle Indicator heading. Mute c…
679c236 
…olors.
stellanl added a commit that referenced this issue Oct 28, 2015
@stellanl
[#1831]Format actual result numbers with thousands separator.
d6e57b7
stellanl added a commit that referenced this issue Oct 28, 2015
@stellanl
[#1831]Format target result numbers with thousands separator.
c6880c7
stellanl added a commit that referenced this issue Oct 28, 2015
@stellanl
[#1831]Color actual and result numbers and comments Red/Orange/Green …
4737ca3 
…for 0%,33%,66% progress.
stellanl added a commit that referenced this issue Oct 30, 2015
@stellanl
[#1831]Color progress 'clocks' according to progress percentage. Impr…
095c92e 
…ove TOC. Improve page breaks.
@KasperBrandt KasperBrandt assigned KasperBrandt and unassigned stellanl Nov 6, 2015
stellanl added a commit that referenced this issue Nov 6, 2015
@stellanl
[#1831]Add Akvo RSR name to footer. Improve Readme file
3b1da68
KasperBrandt added a commit that referenced this issue Nov 6, 2015
@KasperBrandt
[#1831] Add PDF report
954d92d
@KasperBrandt KasperBrandt mentioned this issue Nov 6, 2015
Merged
gabemart added a commit that referenced this issue Nov 8, 2015
@gabemart
Merge pull request #1894 from akvo/#1831-results-report
bdc351c 
[#1831] Add PDF report
@stellanl stellanl mentioned this issue Nov 10, 2015
Merged
KasperBrandt added a commit that referenced this issue Nov 10, 2015
@KasperBrandt
Merge pull request #1898 from akvo/#1831_project_report_with_results
016daac 
[#1831] project report with results
@MichaelAkvo MichaelAkvo moved this to Done in RSR Dec 8, 2022
@MichaelAkvo MichaelAkvo added this to RSR Dec 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@KasperBrandt KasperBrandt

Labels
Type: Results framework
Projects
RSR
Archived in project
Milestone
3.8 Lilongwe
Development

No branches or pull requests
3 participants
@kardan @stellanl @KasperBrandt