reporting services - SSRS tablix Merging cells vertically problem

Question

I found the colspan and rowspan property defined in TablixCell,but in report Designer still can't vertical merge cells,if i modify the RDL xml file manually set Rowspan,the reportViewer show me error info:RowSpan must be 1 for CellContents inside a TablixCell.

is there any other way to implement vertical merge cells of tablix ?

Answer 1

You have to use Matrix instead of Table. I resolved my this problem by creating a matrix same to tablix, below:

1. Insert a Matrix. Right Click->Insert->Matrix
2. Change groupable row to detail row. Right click row->Row Group->Group Properties... Then, in tab "General" Choose "group on" belows "add" and "delete" buttons and click delete to remove group ->OK.

3. Right Click at the first column of Matrix and choose "Delete Column" option. Choose radio button (Delete columns only)->OK

4. Right click on the first row of Matrix and choose "Insert row" option -> outside group - above and then another row will be added to matrix. After that, delete row that you right click previous.

5. Now, you can add row above the detail row and can merge any more