View Revisions: Issue #33629

Summary 0033629: fpreport: Aggregates give wrong results upon ordering of master dataset
Revision 2018-04-22 12:15 by Stephano
Description - Open the attached report
- Preview it
- Add to the department SQL (master dataset) "ORDER BY DEPT_NO"
- Preview it
The aggregate sums for many departments in the ordered preview is wrong, and probably just shuffled.
For instance, Engineering dept's sum should be 132,900.00 whereas it shows as 189,042.94 (which is the sum for "Field Office: East Coast")
Attached are 2 pdf's showing the output for both cases.
Revision 2018-04-22 10:43 by Stephano
Description - Open the attached report
- Preview it
- Add to the department SQL (master dataset) "ORDFER BY DEPT_NO"
- Preview it
The aggregate sums for many departments in the ordered preview is wrong, and probably just shuffled.
For instance, Engineering dept's sum should be 132,900.00 whereas it shows as 189,042.94 (which is the sum for "Field Office: East Coast")
Attached are 2 pdf's showing the output for both cases.