We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Export report in MS Excel on SSRS 2008 via Aspose.Cells for Reporting Services

Hi,

We have recently installed Aspose.Cells on SSRS 2008, dll version is 1.7.0.32

I have a report in SSRS 2008, built in SSRS 2008 R2. This report runs ok, and when exporting results using MS Excel the file gets exported fine. However, when I try to export results using "Excel2007Xlsx - Excel 2007 via Aspose.Cells" I get a single worksheet "ERROR" instead of 5 worksheets that report creates, this error worksheet contains the following:

Error: The same worksheet name already exists

Stack Trace: at Aspose.Cells.x59e54927437fee85.set_x759aa16c2016a289(String xbcea506a33cf9111)
at Aspose.Cells.ReportingServices.ReportItem.x593bccdf2b9e906f.x958045f9b3dbfc27(xcf736b78463acc83 xb5d36a5b57626517)
at Aspose.Cells.ReportingServices.ReportItem.x5d9a63140eb6b015.Render()
at Aspose.Cells.ReportingServices.Renderer.x287918d12b9d430a(Report x64343a0786fb9a3f, NameValueCollection x4d7e972a483f38e6, NameValueCollection x769338e163ee6eb4, NameValueCollection x69ea43ef171861cd, Hashtable& xcc726f61cfb91835, CreateAndRegisterStream x6af66da7eca40f82)
at Aspose.Cells.ReportingServices.Renderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)

Worksheet names in this report are Summary,Detail, Ten,Fifteen, Twenty, so names are not duplicated. It looks like the problem is with page breaks in the report, I have page breaks after each tablix in order for Excel to create a separate worksheet per tablix. Other reports that I have in SSRS2008 and that do not have page breaks get exported fine using Aspose formats.

Is multiple worksheets report export supported in Aspose.Cells? Any suggestions on how to deal with this?

Please help.

Thanks,

Nikolay

Hi,


Please post your sample RDL file here, we will check your issue soon.

thank you.

Hi,

We had checked it and fixed.

Please try the fixed version(v1.7.0.36).

If your SQL server is 2008 R2, please try the version for SSRS 2008 R2 (ACRS2008R2.V1.7.0.36.zip.

If your SQL server is 2008, please try the version for SSRS 2008 (ACRS2008.V1.7.0.36.zip.