Barbara,

FetchSize is the default of 100. Increasing this value does not seem to boosts performance. FetchAsNeeded gets records as needed but you still have to wait. The program does need all of the thousands of records there to return an accurate report. Any other suggestions?

Thanks