Maximum Number of Records

[Anne_Phillips]

This is with R&R SQL Infinity. We have a report that has been run by one of our clients for several years. This month when she ran it - it fell over. I tried it as well with the same results. ie stopped part way through Sorting the records and you get a fatal error. Could this be because the number of records it is now processing has got too large? Is there a maximum and how we can get around this?

[kfleming]

If the SQL report displays a sorting dialog, then the sort is being done locally rather than being passed to the server as an ORDER BY clause. Is the sort field a calculation or total?____When a sort is done locally, R&R uses temp sort files to keep track of things. I do not think that there is an internal limit on the number of sort temp files that could be created. How many records are being processed?____Kathleen__R&R Support