I have the following idea to generate reports in FiveWin using TReport.prg:
Today, the report is created like this:
1) Creates the window to get the filters
2) Do the SELECT - MySQL
3) Rotate the report
4) Opens the automatic Preview, if you are not going to generate .xls or .pdf
So if I have a report with 400 pages, the user won't print everything and won't have time to look at it page by page. If it's a quick report, ok.. but if it takes time to assemble due to the filters, the user is already crazy..
I think you can do it like this:
1) Creates the window to get the filters
2) Do the SELECT - MySQL (NOW with LIMIT in SQL, up to 200 records)
3) Rotate the report
4) Opens Auto Preview
BUT that's just so he doesn't wait so long, if he wants to see the next 200 records, create some navigation buttons in MySQL, pagination even and with Open Preview.
Many reports the guy just wants to see the total or some information, Placing the navigation buttons per page, in such a way that clicking on next, runs the report again with the recordset and shows in the open preview.
This is possible
, there is only the question of when the report with totals or subtotals
