CODEWITHSUNDEEP
reporting-servicesgrouping
kd7iwp
kd7iwp

Reputation: 3140

SSRS Grouping on a field, even when there are duplicates

I have a report in Reporting Services and there is a group that is based around a field value. I want the group to repeat itself on the report as many times as there are rows with that field. The problem is that using Field!field.Value seems to only pull distinct values. Since my dataset has rows that have duplicate values, they are not all showing.

When I declare my parent group, is there a way to tell it to group on every row in the parent group, not just the distinct rows?

Alternatively, is there a list of other options I can use other than just .Value on my field?

Upvotes: 0

Views: 1804

Answers (2)

Mark Struzinski
Mark Struzinski

Reputation: 33491

What about using the RowNumber function (not adding it into the dataset) as an expression to group on?

I don't have a report in front of me right now, but I think that might work.

Upvotes: 1

gbn
gbn

Reputation: 432639

Is there a second field that you can use a "dummy" (aka tie breaker, key etc), to include in the grouping to make it unique?

This is how I'd do it.

Edit: after comment.

Can you add a calculated field to the dataset, such as Rownumber to act as one?

Edit 2: I mean in SSRS itself: "Calculated field"

Upvotes: 0

Related Questions