CODEWITHSUNDEEP
reporting-servicesssrs-2012ssrs-tablix
Aaron Brake
Aaron Brake

Reputation: 370

I am attempting to add a column to an SSRS tablix that must be within a column group but outside of a row group

I currently have a tablix that contains a column that is outside all column and row groups. I'm using this as a Header to create an element that spans multiple rows in order to display as a "grouping". I need this grouping to iterate through columns as well. I cannot seem to, however, add a column that is inside the column group, but outside the row group.

What I would like to have is a tablix where all columns are contained within the column group, but not all columns are part of the row group. Is this possible?

Current Tablix Layout:

Tablix Layout

Current Display:

Tablix Display

Edited for more information:

Currently the output basically looks like this:

enter image description here

I want the output to look like this, where the Header does not repeat with the rows but does repeat with Column Group 1:

enter image description here

Upvotes: 0

Views: 726

Answers (1)

StevenWhite
StevenWhite

Reputation: 6024

I answered a similar question here. In order to get subsequent row headers to span multiple rows, you have to use another table. The tables should be row-grouped on the same fields so that they maintain the same height and appear to be one congruent table.

Now, if you want this setup to be more dynamic where there are a variable number of tables, you can control this using column groups. It sounds like this is what you are actually looking for. So you would have one table with the desired layout. Then put that entire table inside another table. The outer table would have the column group. This way, the inner table gets repeated, headers and all, for each value in the column group.

Nesting tables is a little tricky at first, but offers a lot of flexibility with complex layouts.

Upvotes: 0

Related Questions