title: How to exclude null values from Count() function in reporting services 2005?
body: <p>I am creating a report that has a pareto-like graph and a table of Order Types and how many units of each order type there are. The subset returned from the stored procedure that I am using includes a field called WorkItemId, and if that value is null that means that item isn't to be counted. How should I count Order Types in the report without including the values that have the null WorkItemId? Right now I am using the expression: </p>
  
  <pre><code>Count(Fields!OrderType.Value) 
  </code></pre>
  
  <p>to count the each unit for a specific order type.</p>
  
  <p>Thanks!</p>
  
  <p>EDIT: <strong>WorkItemId</strong> is what cannot be null to be counted, <strong>not</strong> Order Type</p>
  
  <p>Null values in WorkItemId are needed in other reports, so I can't just simply filter them in SQL.</p>