Grouping Difficulty in Microsoft Report Builder

Hello!

I have spent two days trying to figure this out. Talking with ChatGPT isn’t helping much. I am trying to recreate this Crystal Report layout in SSRS:

The main group/sorting is being done by Cust ID which in this example is the 02-626 number.

Crystal Reports says the red box is GH2. I imagine this is a second group nested in the first.

Green box is just “D” details in Crystal report.

All three boxes are one entry, so to speak, meaning it is all the results under the Cust ID. Then it breaks it down into Quotes, then Lines.

I’ve tried various ways to group these to no avail.

Any advice?

1 Like

Can you share what you have tried for the Row Groups in the rdl?

It sounds like there should be 3 Row Groups, the first 2 are groups and the third will be detail.

2 Likes