Thank this author by sharing:
Add Filter Criteria in a table then calculate totals for all fields at the end of the report.
Filters - Report Builder
How do I formulate this statement. I'm not selecting the field;just need to filter on it.
taking count on each field and adding few conditions to the filter
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.