If I need to create another table I can. But that, to me, defeats the purpose of having a report building product.
It is not easier, I don't believe, to add a query and then an inner join.
In Crystal Reports, I right click on the field and hit summary and then count. I'm done.
I was thinking I could do that in SSRS. You probably can, it's just that I don't know the product well enough.
Things will work out. Get back up, change some parameters and recode.