A developer in our group is generating a report that returns the following data:
Date FirstName
LastName Count
Dinner1 Dinner2
10/16/2010 John
Doe 2
PrimeRib Salmon
10/16/2010 Cletus Judd
2
Salmon Salmon
10/16/2010 Some One
2 PrimeRib
PrimeRib
...
She needs to get a count for totals in dinner 1 and dinner 2 as follows:
Dinner 1
Dinner 2
Salmon 1
Salmon 2
PrimeRib 2
PrimeRib 1
Is there a function in SSRS that can do this. We can do this in T-SQL if necessary, but it would be more work. Any suggestions are appreciated.
View Complete Post