|
Hi,
I've developed a report in SSRS 2005. My query is returning more that 65,000 rows and I'm getting an error when exporting the report to excel. Any idea how to solve this?
The report can be exported successfully in PDF
Cheers
Berba
|
|
|
|
|
This is a limit of Excel. I beleive Excel 2010 allows for more than 65,000.
I think you only solution would be to break the results into multiple Excel documents.
Remember to vote.
|
|
|
|
|
Microsoft does not know that Excel can now hold more rows, even when you tell it to use the newer format.
|
|
|
|
|
65k rows is NOT a report, it is a data dump. You are using the wrong tool for the job, you should be exporting the data as csv either from the database or your client application NOT a reporting tool!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The report is loading fine on the asp.net webpage via the report viewer control.
It's just when exporting to excel the customer is getting an error. In PDF it is fine
|
|
|
|
|
berba wrote: It's just when exporting to excel the customer is getting an error
Which means it is the WRONG tool for the job. The tool has a limitation, as pointed out by David and djj.
Never underestimate the power of human stupidity
RAH
|
|
|
|