export to excel

Question

export to excel

Pulivarthi Sasidhar

SSCertifiable

Points: 6706
More actions
November 9, 2010 at 6:26 am

#388191

Hi All,
I have one doubt...
Can i able to export the data to excel without any limitaion.
No of columns =75
No of Rows = 55000
All columns are of VACHAR and DateTime mostly...
In SSRS2005 there was error of "The page cannot be displayed error"....
Can i overcom this if go with SSRS2008
Thanks,
Sasidhar P

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 1

Hi Sasidhar,

As per my knowledge in the rdl the total length of the report can be 406.34 cm , so no matter how many columns you create with in this limit. In case of exporting to excel , the number of rows can be 65000 and number of columns can be 256.

Again even though it is allowing 65000 rows and 256 columns, if the data volume is huge, it might not export even if your number of rows are < 65000 and number of columns are < 256

And I didn't see any difference in the above count in case of SSRS 2008

Friends the above details are as per my experience, but if any of you feel that this is not correct as per your experience or knowledge , please share with us.

Thanks & Regards,
MC

Pulivarthi Sasidhar SSCertifiable Points: 6706 More actions · Answer 2

Thanks for info...

How to find Length of Report....

Does it mean in design

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 3

Correct in design only, I mean the width of the report body.

Thanks & Regards,
MC

ssubudhib Grasshopper Points: 16 More actions · Answer 4

Hi MC,

I have a report, that gets output around 1,50,000 to 2,50,000 rows. But while showing or exporting to excel its showing error. As i know it supports upto 65000 rows.

Is there any possibility for successful exporting to excel by

- Upgrading the reportviewer dlls.

or Upgrading the .NET framework 3.5 (Presently the application is VS2005,Framework 2.0)

Please Suggest...

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 5

Hi,

I don’t think upgrading the .Net framework will help to resolve this. Here the problem is Excel 2003 will not support more than 65000 rows. The higher version supports more than 65000 I guess.

If you are still using Excel 2003, then you might have to try some options so that the entire results will be displayed as more than one result set ( each having rows not more than 65000) so that when you click on each of the results set it will open separate excel sheet.

Also please note that if the data volume is very huge it might even throw an error even if the number of rows is less than 65000 (it could be even a timeout error).

Thanks & Regards,
MC

wcikanek Grasshopper Points: 17 More actions · Answer 6

EXCEL 2007 will get you to 1 million row limit, and 2010 is the same.

dj1202 SSCommitted Points: 1829 More actions · Answer 7

wcikanek (6/19/2012)
EXCEL 2007 will get you to 1 million row limit, and 2010 is the same.

What about bypassing the 256 column limit? Is there anyway to bypass this? I have searched high and low and all I've found is Microsoft's response that "this feature is not yet supported."

wcikanek Grasshopper Points: 17 More actions · Answer 8

Column limit was increase from 256 to 16K in Excel 2007