Search code examples
reporting-servicesssrs-2012ssrs-tablix

How to display only unique child items and their count


I have an ssrs report with dataset that has two fields. I grouped on field 1 and then I grouped on field 2 and now I want to just show the count of each unique items within the child group.

here is what Dataset looks like

Route  Driver
A      Adam
A      Adam
A      John
B      Adam
A      John

and so on

Here is what I'm trying to make my report look like


Route    Driver    Count

A

         Adam      Count of number of times Adam appears in this child group.
         John      Count of John
         Total    total for all


B      
         Adam      25
         Mike       5
         Total      total


C

         Josh       10

and so on

However, here it is what it looks like at the moment.

Route    Driver    Count

A

         Adam      count
                   count
                   count
                   count
                  continues till the number of times Adam appears




B      
         Adam      25
                   25
                   25
                   25
                   continues 25 times

         Mike       5
                    continues 5 times


C

         Josh       10 
                    continues 10 times



here is my design view

enter image description here

Any suggestions on how to do this? I'm open to modifying my dataset too.


Solution

  • Insert a matrix, add route and driver as row groups. In the right most column enter the expression: =count(Fields!Driver.Value)

    design view

    report view