Thursday, July 18, 2013

FortesReports: Misc info

This post will accumulate info on FortesReports, the reporting tool used in Lazarus/FreePascal.

Once enough info has been collected and cleaned up, it will be passed on to the Lazarus group.

- Grouping and ORDER BY
Groups in a report do not force a sort by that field.
If you have a SELECT f1, f2 FROM dooda ORDER BY f2
and create a report which groups by f1, you will end with multiple breaks, as f1 changes values while moving through the recordset.
To avoid that, you will need to SELECT f1, f2 FROM dooda ORDER BY f1, f2

ps: Comments and/or links to this article are most welcome!

No comments:

Post a Comment