PERFORMANCE ODBC SQL SERVER 6.5

[ColinDow]

I Have a report that takes ages to load into the designer(10plus) but once its loaded I can change the criteria and it brings back different result sets very quickly.____Once I distribute it and the user runs it (using OCX) the performance seems to drop to around the same speed as loading the report into the designer. This despite similar criteria being applied by the user.____Im not to bothered by the designer load issue but am keen to speed the runtime performance.____Are there any tips/tricks/ini settings/hints as to how to go about resolving this ?

[kfleming]

[updated:LAST EDITED ON Oct-03-03 AT 12:00 PM (EST)]Try adding the line:__AlwaysRR=1__to the Database section of RSW.INI. It is likely that you will need to add this section name (in brackets which if I try to type here the forum software strips them out) since it is not there by default.____Kathleen__R&R Support