title: Crosstabs Crystal Reports Null value vs zero
body: <p>I'm creating a crosstab report showing the survey history for gopher tortoises (<a href="http://en.wikipedia.org/wiki/Gopher_tortoise" rel="nofollow">if you must know what that is</a>) monitoring stations.  Not all stations are monitored for a given survey and sometimes when we monitor we don't find any and thus record a 0 which is a valid result.  </p>
  
  <p>In the crosstab when the station isn't used I would like it to say "N/A" or some other equivalent, but when it's a zero I want it to stay as zero.  </p>
  
  <p>I've found so much on how to change a null to a zero, but nothing when you want to keep the zero and somehow note the null.</p>
  
  <p>Below is what the crosstab should look like.  You'll see that the 0 in Station4 on 1/1/2004 is "real" (meaning we didn't find any) but all of the N/A's are when we didn't use the station.</p>
  
  <pre><code>                          Survey Dates
  |          | 1/1/2000 | 1/1/2002 | 1/1/2004 | 1/1/2006 |
  |----------|----------|----------|----------|----------|
  | Station1 | 9        | 5        | N/A      | N/A      |
  | Station2 | 5        | 7        | 2        | 6        |
  | Station3 | N/A      | N/A      | 6        | 9        |
  | Station4 | 10       | 9        | 0        | 11       |
  </code></pre>
  
  <p>This is what the Oracle table look like for the 1/1/2000 survey as an example</p>
  
  <pre><code>| SurveyID | StationID | Number |
  |----------|-----------|--------|
  | 1        | 1         | 9      |
  | 1        | 2         | 5      |
  | 1        | 4         | 6      |
  </code></pre>
  
  <p>So, basically how to I keep the zero's and put some text in the nulls in a CR crosstab?</p>
  
  <p>Thanks!</p>