20

Is there any chance to do vertical merge of fields in tablix?

I am working few years on SSRS, but only saw horizontal merge of cells, vertical not.

veljasije
  • 6,722
  • 12
  • 48
  • 79
  • possible duplicate of [SSRS tablix Merging cells vertically problem](http://stackoverflow.com/questions/5447732/ssrs-tablix-merging-cells-vertically-problem) – KyleMit Dec 09 '14 at 18:24

3 Answers3

11

Increase the row height to cover what you need. Insert a table to cover the non-merged cells. It's a little tricky to get the alignment right, but it works.

StevenWhite
  • 5,907
  • 3
  • 21
  • 46
  • This is just workaround, but I have appreciate your effort. If I can't find anything else, this will be the option :) – veljasije Aug 01 '13 at 10:19
  • I have tried it, but now rectangle creates extra td tag and it causes some design issues. can you take a look at this question, http://stackoverflow.com/questions/37588372/rectangle-creates-extra-td-tr-tags-in-ssrs-report – Pedram Jun 15 '16 at 06:09
8

Edit 07/08/2014: Added steps and images.

If you add a row group, it allows vertical merging on the left side of the table. There will be two dotted lines separating the row header and detail. Everything to the left of dotted lines is vertically merged.

If you look at the images from technet there is vertical merging on category and date fields.

http://technet.microsoft.com/en-us/library/dd220511(v=sql.100).aspx

Step 1: Add row group

enter image description here.

Step 2: Assign group

enter image description here

Step 3: Voila! You have a vertical merge

enter image description here

What is your scenario where you need vertical merge?

The other method is what Steven suggested by inserting a table inside a table.

Anup Agrawal
  • 6,551
  • 1
  • 26
  • 32
  • I know for situation where fields are vertically merged inside group, but I need to merge any two or more fields, whether belong to group or not. – veljasije Aug 05 '13 at 07:33
0

As all know, SSSRS provides a simple way to merge cells vertically.

Step for vertical Merge: Select the cells you want to merge > right click > Merge Cells

But in SSRS we can't able to merge cells horizontally. To solve this a bit of thinking gets you a work around for this issue.

To get an effect of merging rows, you can use the same background color and remove the border between common cells.

If you have a text to display, Set VerticalAlign cell property to Bottom enter image description here

And here is the result:

enter image description here

Bibin Gangadharan
  • 1,393
  • 12
  • 13