I can't merge certain cells in SSRS

Question

I have added a row into my report by right clicking the top row and selected add row above. Then when I try and merge all the cells in the new row it doesn't give me the option when I have selected all the cells and right click.

I can Merge 2 or 3 cells but not the whole thing.

My question is why cannot I not merge all the cells? Is there something in the a certain cell I can't see or a creation property that needs to be changed.

Thanks

Answer 1

There seems to be an invisible lines between the row headers and the data, and also the column headers and the data. You cannot merge across these lines.

The solution is to keep you groups and delete the row and column headers. You can put the header rows inside the data area and you can merge cells too.