title: How to sum a field based on a condition in another field in RDLC report?
body: <p>I have an SQL database with <code>skuno</code> and <code>qty</code> columns, with the <code>varchar(50)</code> data type and an <code>int</code> data type respectively.</p>
  
  <p>Here are the columns :</p>
  
  <pre><code> skuno       qty
   -----------------
   78654   -   100  
   65495   -   120  
   10564   -   67  
   64389   -   20  
  </code></pre>
  
  <p>I want to sum <code>qty</code> where <code>skuno</code> begins with a "6" in rdlc report.</p>
  
  <p>I am using this expression but getting an error :</p>
  
  <pre><code>=Sum(iif(Fields!skuno.Value like "6*", Fields!qty.Value, 0))
  </code></pre>
  
  <p>Where is the problem and how can I fix it?</p>