19 Jun 12 17:29
Thanks for your replies.
@kray4660: I have tried running it on a new machine that has good specs (8 gb ram, dual 500 gb hard drives raid0 (don't remember the speed but good), windows 7 ult; icore 7 third gen, etc...), but it hasn't made a difference. I know that the report can load 300k records, just can't process them. I haven't tried processing 200k, but I might try soon. And yes, I never have any apps running when I run CR since it hogs all system resources. I have thought about trying 16 gb and SSD; but since CR really can't utilize a 64 bit environment, I figured it wasn't worth the trouble or $$.
1) I already had "Use Indexes or Server for Speed" checked and I just checked "Perform Grouping on Server" which was not checked and am rerunning the report (although the report does not have groups so I'm not sure this will matter). I'll know by tomorrow AM if anything changed. I have no selection criteria within the report. There are three parameters in the report; two are passed by the stored procedure saying which two data sets to pull, and a third just says whether it needs to be formatted for different export options.
2) I don't see any of these temp files.
3) I'm using a sql stored procedure, since pulling the correct data is quite complex, certain data has weights applied to it before it is passed to CR. For this complex and lengthy report, I don't think it's an option to just spit the numbers into CR from the sproc. I have done that for smaller reports (10 pages) and it is extremely time consuming and difficult.
So, I'm rerunning the report after a fresh reboot and the one option changed per number 1 above and will post the result tomorrow. Any more thoughts are welcome.