p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Reporting Services (http://p2p.wrox.com/reporting-services-205/)
-   -   Merged cells when exporting a report to excel (http://p2p.wrox.com/reporting-services/59351-merged-cells-when-exporting-report-excel.html)

bea June 22nd, 2007 09:18 AM

Merged cells when exporting a report to excel
 

Hi! hope someone can help me.
I have a RS2000 report in which I want to show, for each user, a list of accounts and the amount spent for each user and account, (so the rows are the list of users, the columns are the list of accounts, and the content is each amount).

As the number of accounts is variable, I need a structure with dynamic number of columns, so I used a matrix to show it all, with some groups in it.
The problem is when I export this report to excel, some of the columns are exported as merged cells, and if someone wants to order rows in a different way they are, this message is shown: "This operation requires the merged cells to be identically sized"
What can I do to solve this? I mean, I need each matrix cell to be exported as a simple EXCEL cell.

Thanks in advance :)

Bea




All times are GMT -4. The time now is 05:37 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.