Adjustments to reporting tables

[kreinhardt]

• [x] Can you adjust the organization unit name above the table on all the reports so that the text is larger? To some size that is between what it is now and the size of the "Who Does What" report title in this image:
• [x] Can you also adjust this text to include more information so that when the table is downloaded the content of the table is clear? So the table title would be: organization unit - name of report (role - if applicable) Ex1: Rwanda - Who Does What Ex2: East - Geographic coverage per stakeholder (funder)
• [ ] When downloading the excel version of the reports - this happens: Can you advise on how to address this?
• [x] For the Population coverage per stakeholder report - can you fix the table so that it can scroll like the geographic coverage report?
• [x] Can you also remove the "0%" from the population coverage table - like with the geographic coverage report? So that when there is no data reported for an action/stakeholder, then the cell is blank.

[kreinhardt]

Another thing: not all the actions with no reported data are turning grey:

If having the action where there is no data reported turn grey is difficult - it's ok to just leave the text black. However, I would want this to be consistent throughout the reports.

[abyot]

Hi @kreinhardt,

These are all fixed except the excel warning thing. I do not have a solution for that... the thing is a typical problem of proprietary products. Microsoft Excel checks for strict formatting, literally rejecting anything that is generated with client side technology.

One solution that definitely works is that to tell each machine - that downloads and opens excel reports - not to check for strict formatting. However, this is not a good solution for many reasons.

[kreinhardt]

Thanks @abyot ! The tables are looking good.

It seems like the actions not taking place are not being grey-ed out in the geographic coverage reports. Can you check this?

Can you also remove the option to download as a PDF? The tables look a bit weird b/c there are too wide for a normal page in this format. The excel feature is much more useful for us anyway!

[abyot]

Hi @kreinhardt

Can you tell me the report parameters you have for geographic coverage?

[kreinhardt]

Sorry - I should have included that.

Org unit: Rwanda Reporting level: Province Stakeholder role: Field Implementer (since all acitons have to have this filled....) Actions: All

In the East Province, the action Provide multiple micronutrient supplements (MNPs/Ongera) should be grey, as well as the Schools target group for Promotion of hygiene/handwashing.

[kreinhardt]

It seems to be happening for some:

[abyot]

Hi @kreinhardt,

Have made a fix just now. See if it working this time...

[kreinhardt]

Thanks @abyot - looks good now!

One last change (I hope): can you change the text for the geographic coverage table to:

The table below presents the number and percentage of geographic areas that each stakeholder is supporting. The table can be created separately for each stakeholder role (field implementer, catalyst, funder and responsible ministry). The number and percentage in the table always refer to the sub-national level at which the data was collected. Use the 'Report filters' to define the geographic area, year, stakeholder role and actions to display.

[abyot]

Fixed.

[kreinhardt]

Thanks @abyot . One more.... (sorry, this really should be the last adjustment....)

Can you change the text for the population coverage table to:

The table below presents the percentage of beneficiaries covered by each stakeholder. The table can be created separately for each stakeholder role (field implementer, catalyst, funder and responsible ministry). Use the 'Report filters' to define the geographic area, year, stakeholder role and actions to display.

[abyot]

:(

Ok, I will add this one... but for the next ones, we will have to do it in batch ... like deploying fixes in every other day.

It is a little inconvenient if I have to switch between my codebase and database every now and then

[kreinhardt]

I'm sorry!!!! This is the last one for now but in the future I will provide others as a batch. Thanks for doing all of these though!

I'm going to look through everything again but I think that we are almost ready to clear and build the demo version if you have the description of the metadata structure ready for me?

[abyot]

Fixed. It is ok, it is just that I have to clear all the stuff from dashboard, replace with the mapping one. once done clear all the mapping stuff, replace with dashboard... and then repeat :(

[abyot]

I will try to have the metadata structure description document by Thursday. will that be late?

[kreinhardt]

Thanks @abyot - Thursday for the metadata works for me.

I will continue to double/triple/... check things between now and then in case there is any other changes. However, I don't think there will much... if any.

[abyot]

ok, great.