title: SSRS or SQL Numbers Rounding/Truncating In SSRS Report
body: <p>I am using SSRS to write a report and I am running into a very strange issue.
  I have numbers that are rounding that I do not want to round.</p>
  
  <p>Below are the expressions that are in play.
  I have formatted the textbox to display 4 decimals, default, money, custom, and others with no luck.
  The numbers have the correct decimals to begin with.</p>
  
  <p>So below are the expressions I am using.</p>
  
  <p><strong>Why are the results rounding or truncating when the OR operator is used????</strong></p>
  
  <p>New to SSRS and SQL in general.</p>
  
  <p>Textbox1 has this Expression in it </p>
  
  <pre><code>IIf(Fields!SelQty.Value=1,Fields!EstPrice1.Value * Fields!Qty1.Value,0)
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>2252.2800,
  191.3205,
  505.2300,
  240.8000`
  </code></pre>
  
  <p>Textbox2 has this Expression in it</p>
  
  <pre><code>IIf(Fields!SelQty.Value=2,Fields!EstPrice2.Value * Fields!Qty2.Value,0)`
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>81500.0400,
  5914.0800,
  58166.1600
  </code></pre>
  
  <p>Change Textbox1 to this Expression =</p>
  
  <pre><code>IIf(Fields!SelQty.Value=1,Fields!EstPrice1.Value * Fields!Qty1.Value,0)
  </code></pre>
  
  <p><strong>OR</strong> </p>
  
  <pre><code>IIf(Fields!SelQty.Value=2,Fields!EstPrice2.Value * Fields!Qty2.Value,0)
  </code></pre>
  
  <p>Results</p>
  
  <pre><code>2252,
  191,
  505,
  241,
  81500,
  5914,
  58166
  </code></pre>