RSWEXE Crashes on Complex Reports

[Chris_Ransom_(Guest)]

Using R&R Ver 9.0 I^ve noticed that if I write a fairly complex report and want to export the data to a file, R&R will often error with RSWEXE An error has occurred in your application at the point when it tries to begin the Export routine (the sort routine it runs before the Export begins always seems to work). However if I run the same report for a reduced number of Records by using URN No <=50000 in the filter for example, exactly the same report will work. This is a workaround but it means that to run an export for the whole database I have to re-run the same report several times and change the filter condition to select different URN No ranges. Does anyone else have this problem and has anyone found the solution!

[Chris_Ransom_(Guest)]

It appears to be linked to how much data you want to output. If I want full name, address and phone number data it crashes, but if I just ask for the record number and name it works! Is there some parameter or limit somewhere that I may need to change? This is the SQL Version.

[Chris_Ransom_(Guest)]

No ideas on this one then?

[kfleming]

Are you indeed doing a local sort (so that you see the sorting records counter) rather than having an order by clause as part of the SELECT?____Kathleen__R&R Support

[Chris_Ransom_(Guest)]

Yes I see the record counter box appear and it shows Records Read/Records Selected, then when it starts to Export Records it immediately crashes at this point.____>Are you indeed doing a local sort (so that you see the __>sorting records counter) rather than having an order by __>clause as part of the SELECT? __>__>Kathleen __>R&R Support __