January 31, 2012 at 4:59 am
Hi,
I am having a report SSRS 2008 R2 which will give me the records of more than 1 lack record.I need to save it them in Excel sheet,but i coludn't :w00t: why?
If i run the query in SSMS i am able to save the 1 lack records in excel.
But why cant be in SSRS why there was the limit set in SSRS as 65536
why there no set the limit in SSMS
Why such limitations are there in SSRS alone
I am just comparing with SSMS and SSRS
Thanks
Parthi
January 31, 2012 at 5:04 am
Which version of Excel does SSRS export to? If 2003, you have the 65536 row limit.
Using SSMS, in which version of Excel do you copy paste the results?
ps: keep in mind that this is an international site. Not everybody knows what lakh is.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 31, 2012 at 5:18 am
Koen Verbeeck (1/31/2012)
Which version of Excel does SSRS export to? If 2003, you have the 65536 row limit.Using SSMS, in which version of Excel do you copy paste the results?
ps: keep in mind that this is an international site. Not everybody knows what lakh is.
Which version of Excel does SSRS export to?
Office 2010
Using SSMS, in which version of Excel do you copy paste the results?
I am saving the resukt via results to File opition instead result to grid
Thanks for correcting me it is Lakh and not lack
😀
Thanks
Parthi
January 31, 2012 at 5:37 am
parthi-1705 (1/31/2012)
Which version of Excel does SSRS export to?Office 2010
It seems that it's just not possible in SSRS to export over 65536 rows.
However, a report containing more than 65000 rows is not a report, that's a data dump 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply