Current Caseload Status incorrect numbers


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.




Jason Elwood
August 19, 2018, 1:16 PM

I created a patch for Sinclair to fix the report format issues. It was not committed to Github as somebody should code review

Michael Sultzaberger
November 12, 2018, 10:03 PM

I'm working on this report and I noticed that the Active Count is displayed twice. Should I remove one of the columns?

Michael Sultzaberger
November 26, 2018, 6:56 PM

Expanded the column width to accommodate larger values. Also removed a duplicated column.



Michael Sultzaberger


Jason Elwood



Estimated End Date



Fix versions

Affects versions