Excel Merged Cells

Hi

I'm trying to eliminate merged cells when exporting a report to Excel. My problem being my report textbox above my table.

I've searched and found that making the textbox the same width as the first column eliminates the merging. Perfect, it does. But when the report is viewed in the report viewer, the textbox can only expand vertically. So the title looks terrible because column one is not wide.

I've read that expand horizontally is not an option I don't seem to be able to tell it not to output that text box, which would be an option if there is no other answer I can't have the text box the size I want it, due it creating merged cells I don't want to export it as a CSV

Are there any other options available or am missing something?

Cheers

You can try making the text box the same size as the first and second column or first second and third column if you need your textbox to be larger to accomodate its contents. It's not necessarily the size as much as that it aligns perfectly with one of the columns. I have had a really bad time with the merging of cells also. Sometimes I have to just handle it on the excel side by deleting the title out and then unmerging the merged columns.|||

Thanks for the reply KimberlyL. I tried this and it didn't work. I've tried it again today, making my title text box the width of 5 columns in my table and it still doesn't work, I get merged cells. If I make it the width of 4 columns then I don't get merged cells. So I've reduced the font size so it fits.

It's very strange, I wish I understood why, but at least it works for now

Cheers

|||

If you are exporting to Excel you can't really get rid of the cell merging, not unless you want to write your own renderer. I have read that the RS team is going to look at this problem sometime in the future.

I also had a customer who complained about this, he was trying to copy report values from one spreadsheet to another. In the end i just advised him on the quickest way to unmerge cells: press Ctrl+a, ctrl+1, select the Alignment tab, and deselect the merge cells checkbox. This has kept him quiet

|||

That is what customers had been doing with this report too. But it's not ideal is it! I've also had to remove an image that was placed at the top right of the page header as alligning that up with columns, or anything else I can think of, still adds extra cells and merged cells.

But it does what I want it to do for now. I can see me revisiting this, I just hope the problem has been looked at before I need to!

|||I remember seeing on one of the blogs that sometimes no matter what you do that you can still end up with merged cells. Something about the internal math and rounding that the renderer does. Yes it is very frustrating. I hope that this is fixed in a future release.