Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 No of rows exceeded the limit of Excel file

Author  Topic 

ussr
Starting Member

3 Posts

Posted - 2010-06-01 : 03:24:06
Hi All,
In my report i have 1 Lakh records(rows),
i generated report through report designer and deployed properly.
but while downloading hte report in excel its giving error,
please help me to over come this,
Please go through the error below,
Advanced thanks,
Srinivas

An error occurred during rendering of the report. (rrRenderingError)

Excel Rendering Extension : Number of rows in the Excel sheet exceeded the limit of 65536 rows.

Hi

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-01 : 03:29:56
Upgrade to excel 2007 (1,048,576 rows possible)
or make the number of rows in your report smaller.
I doubt that some wants to read a report with 100,000 rows.


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

ussr
Starting Member

3 Posts

Posted - 2010-06-01 : 05:32:22
quote:
Originally posted by webfred

Upgrade to excel 2007 (1,048,576 rows possible)
or make the number of rows in your report smaller.
I doubt that some wants to read a report with 100,000 rows.


No, you're never too old to Yak'n'Roll if you're too young to die.



Fine and thank you,
Suppose if i have 5,00,000 records, is it going to split in different pages,

Regards,
Sri
Go to Top of Page
   

- Advertisement -