1 Reply Latest reply: May 15, 2014 9:54 AM by Data Kruncher RSS

    Null Values

    Ray M

      I have a Text Report with about 10 templates 1 Detail and 9 Footer.  Everything is working fine with 1 exception.  If the field had no data when I export it to Excel there is a (Null) in each cell.  Is there anyway I can stop it.  I want the cell to be empty if there is no data.  How do  get rid of the (Null)

        • Null Values
          Data Kruncher

          Hi Ray,

           

          To change the null values from showing as Null, go to the Options, View menu and remove default value for the "Display Null values as" option and OK the dialog box. Just leave it blank and the null cells will be empty.

           

          Kruncher