As an admin I want a report that lists all configuration errors for facilities assignments so that I can correctly update the assignments
For every unique Facility and Program combo that is active check for active users in the following way:
User must be active and verified
The required Role Type that should be assigned is SUPERVISION.
The rights can be assigned at a user's Home Facility, or via Supervisory Node
The required Rights that should be assigned: REQUISITION_VIEW, REQUISITION_CREATE, REQUISITION_AUTHORIZE, REQUISITION_APPROVE, REQUISITION_DELETE
One user or more users must have the required rights assigned. (query each of the 5 rights for every facility and program combo. If zero are found, then this is an error)
When records are corrected, the report no longer shows the records.
When the report is run and there are no records, the report shows "No records missing assignments"
Report shows the date it is generated
This new report is located in View Reports
User with Admin Type rights for MANAGE_USERS and Report Type rights of VIEW_REPORTS, is the only user able to run these reports. Users without these rights should not be able to view the report in View Reports tab
Report formats should match existing Jasper formats
Report should list the records that are missing assignments and the following columns:
Assigned Supervisory Node
Comfort Health Clinic
Nandumbo Health Facility
store manager, storeroom manager
The manual process of resolving these errors is out of scope
I mean the rows without any text that are visible between the "Facility Name" and "Facility Type" columns, and between "Assigned Roles" and "Assigned Superv. Node" columns. I don't think such big spaces between columns are necessary; e.g. between the "Facility Code" and "Facility Name" there are none, and the data are still easily readable.
Okay, please create a new Bug ticket for the formatting issues that you have reported here. It sounds like Paweł suggests we create a separate Bug ticket for addressing the formatting. (This ticket, 2760, was marked Done and moved off the board a sprint ago.)
Respecting CSV issues, this is how Jasper generate CSV, we can't really adjust that but we can exclude some template "bands" (like report header with template title) from printing in chosen format. I believe it is reasonable to have in CSV just headers and values without title, date and so on. What do you think about this?
Regarding the CSV formatting, I think it is better to have a few blank rows rather to have missing information (title, date and so on).
All right, in that case, I agree with Brandon - the completeness of information is more important than formatting.