Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Merging Cells Vertically in SQL Reporting 2008

Tags:

ssrs-2008

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

like image 546
JonathanWolfson Avatar asked Aug 05 '09 20:08

JonathanWolfson


3 Answers

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.

like image 193
Patrick J Collins Avatar answered Jan 04 '23 01:01

Patrick J Collins


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

like image 44
jgallant Avatar answered Jan 04 '23 02:01

jgallant


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) http://i.stack.imgur.com/WA2ZL.png

like image 41
user2570774 Avatar answered Jan 04 '23 02:01

user2570774