I have a particular report, where report gets generated within 15 seconds with nearly 480 pages. But when i try to export this report to excel it gets timed out after 2 minutes. I've tried this few times and every time it took 2 minutes to time out. Can any one advise me how to change this default time? I want increase this time more so that SSRS get some more time to export the data into excel. OR else is there any other solution of this problem( i.e. Is there any configuration settings for this purpose that can be changed in order to resolve this problem )? Thanks.

Since you mentioned the report is nearly 480 pages, I suspect that this is caused by the limitation in maximum number of rows in excel. Excel 2003 has 65,536 rows as the maximum. Please check exporting an output with less number of pages to excel just to ascertain if the volume of data is the cause. Hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi Sayan, At 480 pages this is effectively a "data dump" not a report. You have probably chosen the wrong tool for a "data dump", but you may have more success exporting in CSV format. Good luck! Mike

Hi, Which version of SSRS you are using? In SQL 2008 R2, when number of rows exceed 65536, we use to get below error "Excel Rendering Extension: Number of rows exceeds the maximum possible rows per sheet in this format; Rows Requested: 65541, Max Rows: 65536 (rrRenderingError)". So, as suggested earlier first option is to try export to some other format (CSV can be a good option) and see if error exists. Also, try limiting number of rows to 10 for demo and then try exporting to excel, see if this works. If this does not work, there might be something wrong with excel renderer on your SSRS server. Kindy revert in case you have any other doubt.- Chintak (My Blog)

Thanks for the replies. Data is exported properly when number of records is less.Records are less than 65K (its around 20K).It works perfectly fine locally on the report server.Same is true while accessing report from the Application Server Problem is application gets logged out in 2 mins(exact 120 seconds) while rendering takes about 10 mins to complete. Is there any configuration which can allow the application to wait for the report server longer?

Did you check the report execution timeout? 1. Go to report manager 2. click on Site settings (located on top right of the screen) 3. Check the value set for 'Report Execution Timeout'Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Bilal,Report Execution Timeout is set to 1800..!!

Hi Sayan, We are also facing similar problem. We are gettting timedout when the report has more than 8k records. Did you find any solution for this? Thanks, Prawin