Hi,I have created one report. In this report, I cantoggle 4 times to totally expand the report (5 layers of grouping)It needs to view the report in IE and export the report to PDF/Excel format. I can view the report in IE and export to PDF in all cases, but it fails to export the report to Excelin some cases.If the period (report parameter) is short, say 1 month, the report can be exported to Excel successfully.but if the period is too long, say2 years, the report cannot be exported to Excel (Obersevation: "w3wp.exe" uses 100% CPU resources).I guess there are too many data to load and Excel fails to handle this huge amount of data.Is there any limitation in exporting reports to Excel? Does Excel has any limitation? or any other solution to this problem?Thanks very much!SQL Server 2005 SP3, SSRS 2005

Hi,Excel has some LimitationsCheck this link for Excel Limitationshttp://msdn.microsoft.com/en-us/library/ms156418.aspxRajesh Jonnalagadda http://www.ggktech.com

Hi, I have the same problem - SSRS 2005, Excel 2010. Thanks very much!