Counting Multiple Values From The Same Column And Grouping By A Another Column

This is a report I'm trying to build in SQL Reporting Services. I can do it in a hacky way adding two data sets and showing two tables, but I'm sure there is a better way.





TheTable


Order# Customer Status





STATUS has valid values of PROCESSED and INPROGRESS





The query I'm trying to build is Count of Processed and INProgress orders for a given Customer.





I can get them one at a time with something like this in two different datasets and showing two tables, but how do I achieve the same in one query?





Select Customer, Count (*) As Status1


FROM TheTable


Where (Status = N'Shipped')


Group By Customer