Getting Total Of Different Records

I have a SQL data source and i would like to present the total number of different records based on a "status" field.

I have done total records in the past by doing this:

     protected void SqlDataSource1_Selected(object sender, SqlDataSourceStatusEventArgs e)
    {
        int RecordCount = e.AffectedRows;
            if (RecordCount == 1)
            { litRecordCount.Text = "1 record found"; }
            else
            { litRecordCount.Text = RecordCount.ToString() + " records found"; }
        }

This would work, howerver, my SQLdatasource choose * records, and not based on a WHERE condition. Is there any way to total just those with a status of "Initialized" ?

I tried to do it on the Gridview, but then I realized if I have paging on, it will only be on that front page.

thoughts?