Suppress Null Date to display

Comments

• pinbot Texas

  December 2010 edited 11:21AM

  
  There is a "NullValue" property you can set to display a specific value when the data is null.
  
  
  
• inetMark

  December 2011 edited 11:21AM

  Property NullValue not work for me.
  I have Date field. On that field is assigned format for date, but when column is null, it will show "01.01.0001".
  If I insert something into NullValue, it will always stay same.
• inetMark

  December 2011 edited 11:21AM

  DavidWard wrote: »

  Try the AfterData event instead of BeforePrint, when BeforePrint fires the data fields have not yet been populated

  
  I dont use BeforeEvent even AfterEvent.
  I use only NullValue property on object, ant this object has format set to Date.
• sokac

  April 2012 edited 11:21AM

  inetMark wrote: »

  inetMark wrote: »

  Try the AfterData event instead of BeforePrint, when BeforePrint fires the data fields have not yet been populated

  
  I dont use BeforeEvent even AfterEvent.
  I use only NullValue property on object, ant this object has format set to Date.

  
  Set TextObject's HideZeros property to true.
• maxhugen Australia

  April 2016 edited 11:21AM

  sokac wrote: »

  sokac wrote: »

  sokac wrote: »

  Try the AfterData event instead of BeforePrint, when BeforePrint fires the data fields have not yet been populated

  
  I dont use BeforeEvent even AfterEvent.
  I use only NullValue property on object, ant this object has format set to Date.

  
  Set TextObject's HideZeros property to true.

  
  Also: you can uncheck Report > Options > General tab > Convert null values.
  As datetime is numeric, this setting will convert a Null datetime to zero !
• Stark Syria

  April 2016 edited 11:21AM

  You could Add Expression to replace the date string '01-01-0001' to Empty string.
  
  

  Screenshot_2.png 6.2K
• ericchua

  September 2017 edited 11:21AM

  Stark wrote: »

  You could Add Expression to replace the date string '01-01-0001' to Empty string.

  TRY THIS

  HIDE_NULL_DATE.PNG 127.3K
• ericchua

  September 2017 edited 11:21AM

  Ultraman wrote: »

  Hi Alex
  
  I have downloaded the trial version and doing a compare with XtraReport, crystal report for my company ERP, your fastreport by far the best I tried, but I have this problem, why when the date is null, it always print 01-Jan-01?, anyway can I supress it to print BLANK or '-'?
  
  I have tried using the Beforeprint evernt to check for DBNull, but it does not work...
  
  Any help?
  
  Dr. Lee

  
  
  TRY THIS

  HIDE_NULL_DATE.PNG 127.3K