Hi,

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.

Thanks.