Free Support Forum - aspose.com

Exporting to Excel without merged cells

Hi,

Has anybody been able to export from Reporting Services (SQL Server 2005) using Aspose.Cells for Reporting Services without having merged cells?

I have a report in Reporting Services as described below

Cat1 Cat2 Quanity Value

Clothes Pants 100 200
Socks 200 500
Shirts 50 1500

When I export it to Excel I want it look like this

Cat1 Cat2 Quanity Value



Clothes Pants 100 200

Clothes Socks 200 500

Clothes Shirts 50 1500

Without any merged cells so that the end user can filter on the data without needing to do any formatting. Can Aspose.Cells for Reporting Services do this?

Hi,

Well by default the merging retains as it should be when the report is rendered to excel. Any how we will check to get back to you soon.

Thank you.

Thanks very much. I need the cells to un-merged as my client would like to filter on the data returned which looks impossible if you have merged cells?

Dear redowl

Please post your rdl file.

Thanks for your help.