CODEWITHSUNDEEP
reporting-servicesvisual-studio-2015
Scott Moore
Scott Moore

Reputation: 1

Repeating SSRS Matrix Column Headers SSRS 2015

I have an Excel Pivot that I want to reproduce in a SSRS Matrix.

The Excel Pivot looks like this:

Excel Pivot

Notice the first column header "Full Face Masks" repeats on each column.

My SSRS matrix looks like this:

SSRS Matrix

Notice how "Full Face Masks" does NOT repeat, despite repeating turned on.

As suggested, I've added an image of the Design View:

Design View

I've read through DOZENS of answers/sites related to repeating column headers.

I've even gone through the XML line-by-line to see if I can find an answer, but no luck.

So, in SSRS 2015, how do I make my report look like the Excel Pivot image. I KNOW it's possible -- I've seen it done but yeah... I can't figure it out.

[1 - Excel Pivot]: https://i.sstatic.net/kVNnG.png
[2 - SSRS Matrix]: https://i.sstatic.net/EKmq7.png
[3 - Design View]: https://i.sstatic.net/du4f8.png

Upvotes: 0

Views: 684

Answers (1)

Alankrit Agrawal
Alankrit Agrawal

Reputation: 109

This is a common problem which occurs when you use groups. You need to do the following thing to resolve this:

  1. Add a row above the group, this row will be created as outside the group. Put the values that need to be repeated in the matrix and shown on the report.

  2. Remove Group columns from the matrix. Do not remove the group, only remove group column from the matrix.

Upvotes: 2

Related Questions