fpreport: Aggregates give wrong results upon ordering of master dataset
Original Reporter info from Mantis: Stephano
-
Reporter name:
Original Reporter info from Mantis: Stephano
- Reporter name:
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.
Mantis conversion info:
- Mantis ID: 33629
- Version: 3.1.1
- Fixed in version: 3.1.1
- Fixed in revision: 38810 (#2a80d2ad)
- Target version: 3.2.0