I am building the report using SQL report builder and "where" is not an option I thought. It doesn't work when I use: =Sum(Fields!Surgical_Case_Count.Value) where (Fields!Wait_Status.Value="Within Target")