August 27, 2013 at 8:30 am
Hi Folks,
When i am trying to export my report into xls, i am having some issues as i am unable to save more than 65k rows of data and i dont see any option like selecting .xlsx file while saving the report.
By considering the fact that I have SSRS2008 R2 in place and excel 2007 in place and how can i export or save the report in i have got one million of records?
August 27, 2013 at 1:09 pm
TomGuide (8/27/2013)
Hi Folks,When i am trying to export my report into xls, i am having some issues as i am unable to save more than 65k rows of data and i dont see any option like selecting .xlsx file while saving the report.
By considering the fact that I have SSRS2008 R2 in place and excel 2007 in place and how can i export or save the report in i have got one million of records?
The 65k export limit seems to be a limit of SSRS. There does seem to be a work around; take a look at these:
http://www.bi-rootdata.com/2012/10/efficient-way-of-handling-excel.html
HTH,
Rob
August 27, 2013 at 1:20 pm
.xlsx is supported in SQL Server 2012, but not in earlier versions.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply