Somashekhar
Somashekhar

Reputation: 513

Exporting to Excel in SSRS getting error when it crosses 65,000 rows

Exporting to Excel in SSRS getting error when it crosses 65,000 rows

I am using ssrs (BIDS) to create reports, I struck in exporting to excel when it crosses 65,000 rows. how to solve this problem in ssrs reports

Upvotes: 0

Views: 3016

Answers (3)

Diego
Diego

Reputation: 36176

That's an excel 2003 limitation and SSRS does not support excel 2007. You need to export to csv or add groups on your report (with 65k max rows) so each group will be exported as on sheet on the excel document

Upvotes: 0

Somashekhar
Somashekhar

Reputation: 513

I got the answer and I hope this is the another way to solve the above problem

generate sql table like this

col1 col2 grp

1 2 1

2 3 1

4 5 1

2 4 2

4 5 2

and give group by column as "grp" and make visiblility false for grp textbox in ssrs report. also in page breaks properties check the "between each instance of a group" checkbox. when you exprot to excel the data will come in differnt sheets for diffetent groups.

user this link for query - Increase row count in sql server after some count (say 25,000)

Upvotes: 0

Colin
Colin

Reputation: 855

Are you exporting as an .xlsx file? I know in pre-2007 Excel (.xls) the maximum row count was about 65,000.

Upvotes: 1

Related Questions