title: Crystal Report: If-Else If Formula
body: <p>For one string field in crystal report i wish to write up formula where if that field is null, it should display as "No value" else  the actual values should come up</p>
  
  <p>What i have written is</p>
  
  <p>Local StringVar x;
  If {mysp;1.mystringfield} ="" or IsNull({mysp;1.mystringfield}) then
  x := "No value";
  <strong>Else
  x := {mysp;1.mystringfield}</strong></p>
  
  <p>The bold marked shows error saying "the remaining text does not appear to be part of the formula crystal reports"</p>
  
  <p>Whats incorrect in my formula?</p>
  
  <p>Let me know for more inputs</p>
  
  <p>thanks</p>