I have SSRS 2005 report. The report displays 10,000 of records successfully, but when the report is supposed to display lakhs of records, the report gets time-out.
I have also tried the below changes but still the timeout occurs. 1) In Report manager have selected the "Do not timeout report execution" option. 2) In Machine.config changed the <processModel autoConfig="true" /> to <processModel autoConfig="true" memoryLimit="120"/> 3) In rsreportserver.config changed "MemoryLimit" and "MaximumMemoryLimit" to 120 and 160 respectively.
Let me know what else can I do to avoid the timeout.