开发者

SSRS tablix Merging cells vertically problem

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 ?


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.

SSRS tablix Merging cells vertically problem

SSRS tablix Merging cells vertically problem

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

SSRS tablix Merging cells vertically problem

  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.

SSRS tablix Merging cells vertically problem

SSRS tablix Merging cells vertically problem

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

SSRS tablix Merging cells vertically problem


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.

SSRS tablix Merging cells vertically problem

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


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


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜