The Caseload Status Report is displaying incorrect values in several of the program status columns. This was discovered in the field and verified in their environments. The report is cutting off digits from the program status columns under a few conditions. In this case, the report is incorrectly recognizing all the digits in the sums that are being done for the program status columns. The Total Count and Active Count columns are correct.
Here’s when the truncation of digits is happening.
1. The Total Count column value is 2000 or larger. When that happens, digits are truncated from the report results in the program status columns.
2. The truncated digits seem to be happening to all the columns except Non-Participating when the result is three digits or more. Of course there could be other combinations of the program statuses that cause the NP column to display incorrectly. When the program status result is only 1 or 2 digits, there doesn’t seem to be any truncation. Here are example report and correct values for a coach with more than 2000 in the Total Count column.
Active: 153 (report), 1531 (actual)
Inactive: 268 (report), 26840 (actual)
Transitioned: 141 (report), 1412 (actual)
Non-Participating: 3875 (report), 3875 (actual)
No Show: 131 (report), 1313 (actual)
The actual numbers were verified by impersonating the coach and using filters in the Caseload and running the corresponding queries. It seems to be a truncation of digits problem when the report is rendered.
I created a patch for Sinclair to fix the report format issues. It was not committed to Github as somebody should code review
I'm working on this report and I noticed that the Active Count is displayed twice. Should I remove one of the columns?
Expanded the column width to accommodate larger values. Also removed a duplicated column.