user3206700
user3206700

Reputation: 15

SSRS Report Builder: showing detailed data in the middle of a report, "within" a parent group

I've been struggeling with this issue for a while now and can't seem to figure it out.

Is it possible in SSRS to have a parent group in my report, then some data in a child group, and then to the right of that columns some more data grouped the same way as the parent group? Parent groups automatically appear on the left of my report, how do I get one on the right so that my report looks something like this: example

So I want the data in column 4 to be grouped the same way as columns 1 and 2. Is this possible?

Hope you can help, thanks!

Upvotes: 1

Views: 989

Answers (1)

StevenWhite
StevenWhite

Reputation: 6034

You can get this behavior by having two tables next to each other. "Column 4" from your example would be the first column of the second table. Both tables would be grouped the same way. The trick to getting the second table to have the same height is to still include a details group. So the second table will still have another column that is grouped, but you can make it invisible.

Here is an example of the design for the layout: enter image description here

And here is the result:

enter image description here

Upvotes: 0

Related Questions