CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2
jhowe
jhowe

Reputation: 10878

SSRS Count grouped rows

I have a report where i'm trying to SUM row counts (or SUM count ID) per group. I'm not sure how to do this in SSRS. The report looks like below

enter image description here

and I'm trying to create the highlighted area in red. How can this be done? The problem is the rows above the red area are already in a group...

I've tried Count("Group1"), =Count(ContainerID) but when i do count on the ID field it's giving me a count on ALL the records in the data set and not what's above... Any ideas? I've inherited this report and have been asked to make changes to it...

Upvotes: 0

Views: 757

Answers (2)

jhowe
jhowe

Reputation: 10878

I resolved this issue by using =CountDistinct(ContainerID.Value) in No of Containers field.

Upvotes: 0

Chris Latta
Chris Latta

Reputation: 20560

You aren't restricted to doing everything in the one table.

Create a second table under the one you show here based on the same dataset, group by destination, show the count, and hide the detail row.

Upvotes: 0

Related Questions