I have a select statement joining several tables.  An aggregate report
will be deployed in Reporting Services.  On the Layout tab, I have a
table where I want to place the results.

For example, I have the following result set from the table join
statement

                  Has Paws
bear            True
cat              True
dog             True
duck           False
chicken       False

On the aggregate table, I want to have this:
# of Animals Having Paws         # of Animals Without Paws
              3                                                   2


I've tried the Aggregate Count function, which returns
# of Animals Having Paws         # of Animals Without Paws
              3                                                   3
              3                                                   3
              3                                                   3

Everywhere else utilizes some form of a Select statement, which errors
out for a cell formula in a table.

Any help would be most appreciated!

Thanks!

Clustered Index Not Working
Stored procedure to change not nulls to nulls
To write SPs, or not to write SPs, that is the question....
Learning SQL
MCITP 077-444