CODEWITHSUNDEEP
ssrs-2008
JonathanWolfson
JonathanWolfson

Reputation: 861

Merging Cells Vertically in SQL Reporting 2008

In SQL Reporting 2008, Is there a way to merge multiple cells that are adjacent to each other along a vertical column?

Upvotes: 5

Views: 14492

Answers (3)

user2570774
user2570774

Reputation: 11

You may use matrix table to do it. It force you to have a group column, however you can just set the group column visibility as Hidden. Then add new columns you needed. see image here: ( my Month is merge cells from two rows) https://i.sstatic.net/WA2ZL.png

Upvotes: 1

Patrick J Collins
Patrick J Collins

Reputation: 1009

In the report designer, click on your table, then at the bottom of the screen there is a window spit in two with the headings "Row Groups" and "Column Groups". In row groups, click on the little down arrow next to the default group "table1_Details_Group" and choose to add a parent group. Select the field you want to group on, and don't check the boxes to add a row header or footer. A new column will be added and when you preview you will see that the cells of this column are merged vertically.

Upvotes: 5

jgallant
jgallant

Reputation: 11273

You cannot merge cells vertically, only horizontally.

You can, however, create table groups. Grouped data inside a table can be designed to look like merged vertical cells.

EDIT

INFORMATION ON MATRIX CONTROL

Upvotes: 2

Related Questions