CODEWITHSUNDEEP
matrixreporting-servicesstaticpivot
AlanPear
AlanPear

Reputation: 727

Remove Tablix Static Columns Row Groups in SSRS

I have a report in SSRS that uses a matrix with static columns. Here are the static columns:

enter image description here

After generating the report, the rows with same values end up being grouped together:

enter image description here

Is there any way to get rid of these groups? I'd rather the values be repeated for each row, so it looks more like an excel sheet.

Here is a better picture of my report design plus the row and column groups. These groups were created when I added them to the matrix and are not needed as far as what I can tell for my report:

enter image description here

Upvotes: 0

Views: 4789

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21683

As you are not doing any calcuations on hte row gorups, there is no need for them.

Delete all but one of the row groups by right-clicking the rowgroup in the Row Groups pane at the bottom of the screen and choosing Delete Group. If prompted, choose Delete Group Only, otherwise it will delete the associated columns too.

When you noly have one group left, right-click it and choose Group Properties and delete the group expression, this will change it to be a details style group.

Make sure the Hide Duplicate expression is back to default (blank or None) in case you changed it earlier.

That should work. I replicated a similar scenario to your and the above step did the trick.

You will probably also need to go back to your group properties and set the sorting options to ensure data is sorted correctly.

Upvotes: 1

Related Questions