23

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 ?

guaike
  • 2,471
  • 9
  • 31
  • 42
  • 1
    Contrary to the prevailing opinion here, you can do this with a tablix, and the process is similar to the one Jonathan posted for the matrix. For the steps to take, see my answer to a similar question at https://stackoverflow.com/a/52122160/4879622. – bryc3monk3y Sep 03 '18 at 23:08

4 Answers4

20

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.

enter image description here

enter image description here

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

enter image description here

  1. 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.

enter image description here

enter image description here

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

enter image description here

Jonathan
  • 1,017
  • 10
  • 21
13

If this is only for display purposes, you could try putting a table inside a table. SSRS will let you do this if you delete the grouping columns on the outside table.

Example SSRS Table in Table

Otherwise you are limited to the vertical grouping with Matrices, which still has restrictions on where the vertical merging takes place.

scourge192
  • 1,909
  • 16
  • 22
  • 1
    I upvoted this and now can't remove the upvote, but it doesn't work to use this method for layout purposes as you get an error: detail members can only contain static inner members – Catherine Apr 07 '14 at 10:58
  • 2
    @Catherine, when you put a chart or table inside the cell of another table, you need to make sure the "parent" table's row group has a group expression. If the table is selected along the bottom you should see a pane with "Row Groups" and "Column Groups". Double-click on the "(Details...)" group and add a group expression there. – Eilert Hjelmeseth Jul 24 '15 at 13:39
  • The nesting tables works very well, except when I set up a subscription to have the report emailed to me. When rendered in outlook, the nested tables do not fill the cell they're in so it looks awful. – Eilert Hjelmeseth Jul 24 '15 at 13:43
5

So my trick is I highlighted the top row of the column I wanted to merge the cells, and changed the border properties to remove the bottom line. When you preview the report, the cells look merged.

MRawrawk
  • 83
  • 2
  • 4
5

As far as I know, the only way to merge vertically, is to use a Matrix instead of a Table.

http://gotreportviewer.com/matrices/index.html

jgallant
  • 11,143
  • 1
  • 38
  • 72
  • Hi,Matrix just can use in VS2008 or Vs2005,VS2010 cannot support it,In vs2010 using Tablix replace it,i am talking a about tablix merging cells problem. – guaike Apr 08 '11 at 12:59
  • 1
    Have used a Matrix with no problem in VS2010 - not sure what you mean here? Had the same issue and confirm you can only merge vertically in a matrix, cannot be done in a table. – Rich Jul 27 '11 at 14:45