title: In crystal reports how to I make a default value appear on a null?
body: <p>I'm using VS 2010 but I'm not sure on the Crystal reports what year it is. 2008 or 2010?  I want to display 'N/A' when a date field is null.  here is my formula</p>
  
  <pre><code>  If isnull({usp_print_get;1.Cit_Date}) then 'its null' else 'not null'
  </code></pre>
  
  <p>It will print 'not null' when there is a date but if there isn't a date it just leaves the space blank instead of printing 'its null'  I've checked the database and the date field for that record is indeed null and not a space or empty string.  Any help is appreciated. Eventually I'd like to print either 'N/A' when its null or the actual Cit_Date. Right now I'm just using the strings to test.</p>