In SSRS Export to Excel is still in Excel 2003 format, which limits exports to 65,000 rows .So,How to exports more rows than 65,000 in excel in SSRS 2008.?
hello,
well i am having a problem .as
In SSRS Export to Excel is still in Excel 2003 format, which limits exports to 65,000 rows .So,How to exports more rows than 65,000 in excel in SSRS 2008.?
i need to export more than 65,000rows data ,so how could we obtain this in SSRS 2008.Is there any alternative solution for this ..after i researched a lot i concluded that SSRS Export to Excel is still in Excel 2003 format, which limits exports to 65,000
rows.
so plz help me out.?
Thanks
Anil Maharjan
November 18th, 2010 4:56am
Hi Maharjan
Sql server Reporting Services do not have the ability to export reports to Excel 2007.
However, Sql Reporting Services 2008 R2 has an improved functionality with which you can use the third party tools to export reports to Excel 2007.
Ex. Softartisans Officewriter, Aspose cells for Reporting sercices, Etc
Thanks!!- Kerobin
Free Windows Admin Tool Kit Click here and download it now
November 18th, 2010 5:17am
thanks for response kerobin....
ya i also found such kind of information as
Alternatively, use the SSRS report as a data source for Excel PowerPivot, and you can get past this limitation within Excel 2010.
so we cannot export with in excel 2007 .. :( ..with out using a third party ..humm..
November 18th, 2010 5:31am
Hi Maharjan,
We can use a page break to export the data into multiple Excel sheets, this can work around the issue.
Here are a lots of similar threads for your reference:
http://social.technet.microsoft.com/Search/en-US/?query=excel%2065536%20page%20break&rq=meta:Search.MSForums.ForumID(055ccfc1-78f5-46ff-8171-33f8ff760a7c)+site:microsoft.com&rn=SQL+Server+Reporting+Services+Forum
Thanks,
Jin ChenJin Chen - MSFT
Free Windows Admin Tool Kit Click here and download it now
November 22nd, 2010 3:10am