1. Open your report
2. Go Database > Show SQL Query
3. Copy the SQL Query
4. Create a new report connecting to the same database, but this time use "Add Command" option
5. Paste the SQL query to the Command window and modify the first line - use "Select Top 1000000" instead of the simple "Select"
6. Refresh the report. If it works increase the number
Can we get some more information?:
1. Fields could be just numeric fields or could be Memo type fields up to 2048 characters long. It makes a difference for memory consumption
2. Three tables are linked or not? It also makes a difference.
Run report with Task Manager open and monitor memory consumption. If memory goes above 1.7 GB then it probably hits 2 GB Windows limitation for 32 bit application.
That is what I expected - 1.6 GB definetely means you are reaching 2GB Windows limitation. No ways to change the limit.
Another workaround solution is to reduce the number of columns in the report.
Add comment