We're updating the issue view to help you get more done. 

Current Caseload Status incorrect numbers

Description

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.

Environment

None

Status

Assignee

Michael Sultzaberger

Reporter

Jason Elwood

Labels

None

Estimated End Date

None

Audience

None

Components

Fix versions

Affects versions

SSP 2.9.0

Priority

Minor