Andy K
Andy K

Reputation: 5085

SSRS line subgrouping by lines and not by columns

I want to have a row subgroup that will act like a head line with the details belonging to each subgroup (see below)

enter image description here

This is what I've done so far

  1. Add a parent row group with the field LibelDestinataire as you can see in the picture

enter image description here

  1. This is the result I have

enter image description here

Something is wrong but I'm unsure where. I've used a table. I've tried with a matrix but it did not do what I expected.

Any tips are welcomed.

Upvotes: 0

Views: 39

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14118

Create a new tablix, right click the details group, select Add Group / Parent Group and use this settings:

enter image description here

You will get a tablix like this:

enter image description here

Delete the left most column (created by the group).

enter image description here

Delete the first row and use the LibelDestinataire field in the selected cell.

enter image description here

Merge the three cell next to the first cell and set the other fields in the next row:

enter image description here

You will get something like this:

enter image description here

In preview it should be something like this:

enter image description here

Apply the color and formats you want to cells and you will get the desired result.

Let me know if this helps.

Upvotes: 2

Related Questions