title: Crystal Report if-then statement
body: <p>i have a database that contain some measure. The problem is that the measure are saved in the main units (for example, 1 mV is saved as 0.001 V).
  Now I use crytal report to generate a report with these measure, but I want to convert 0.001V into 1mV.</p>
  
  <p>How can i do this?</p>
  
  <p>I tryed with:</p>
  
  <pre><code>if lcase({database.result_type})="eval" then
    {@Test_Result}   
  else
  (
      if {database.measure}&lt;0.001 then
        {database.measure}*1000000 &amp; "uV"
      else if {database.measure}&lt;1 then
        {database.measure}*1000 &amp; "mV"
      else if {database.measure}&lt;1000 then
        {database.measure} &amp; "V"
  );
  </code></pre>
  
  <p>but it doesn't work. The first IF is to understand if it's a PASS/FAIL test or a measurement.</p>
  
  <p>How can i do?</p>