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
|