SSRS export to excel has problems sorting due to merged cells

Aspose.Cells Product Family
1

Hi,

We use SSRS 2005 and we have a problem when exporting to excel and then trying to sort the data. From what i can tell you have a custom rendering engine for Excel which may solve our problem..

The problem we are trying to eliminate is when sql server reporting services exports a report to excel it will merge some cells in order to keep the format. The problem is that excel will then not let you sort the columns due to these merged cells. Our users often export to excel and then tweak the data.

I have found it quite difficult to find out exactly what your rendering engine offers over the stadard one MS offers.

Have you heard of this issue before? here is a link for more info:

http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx

Hope you can help even if it is just to say this isnt possible to fix.

I have attached a sample excel export generated from a report i knocked up using adventure works to replicate the issue.

Kind Regards

Dave Hunt


2

Hi Dave,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Thank you for considering Aspose.

Please try Aspose.Cells for Reporting Services designer and render your report. Aspose.Cells.Report.Designer (Aspose.Cells for Reporting Services client) uses MS Excel as a designer to design a report template, therefore you can take advantage of all the powerful functionalities / features available in MS Excel including Pivot Tables, Interactive Charts, VBA, Macros and Formulas.<?xml:namespace prefix = u1 /> All these attributes are not supported by the standard MS Excel format delivered by Reporting Services. After designing the report template, it is then embedded into Reporting Services RDL file and can be published to Report Server.

Please check the online documentation for further details:

http://www.aspose.com/documentation/ssrs-rendering-extensions/aspose.cells-for-reporting-services/index.html

Thank You & Best Regards,