How to determine if a field is null

Comments

• AlexTZ

  February 2010 edited 8:58PM

  Try
  IIf([ds.EntryDate] == null || [ds.EntryDate] is DBNull, "<no date>", [ds.EntryDate])
• Xavi

  February 2010 edited 8:58PM

  I have tried your response, but it seems not working. If I click View Data, in the Data panel, I can check that the field is blank.
  
  I am using:
  
  [IIf([ds.EntryDate] is DBNull || [ds.EntryDate] == null, "<NULL>", [ds.EntryDate])]
  
  and I FR prints out 01/01/1001 0:00:00
  
  I would expect to see <NULL> because the field is null, checked in View Data panel and in other tools.
  
  I am using Firebird as database, maybe it could be relevant.
  
  Thank you
  
  
  
• AlexTZ

  February 2010 edited 8:58PM

  I forgot to say that the "Convert null values" option must be off.
• Xavi

  February 2010 edited 8:58PM

  It is off
• AlexTZ

  February 2010 edited February 2010

  Ok, here is the correct code:
  [IIf(Report.GetColumnValueNullable("ds.EntryDate") is DBNull, "<NULL>", [ds.EntryDate])]
  
  You may also use the "NullValue" property of the Text object:
  Text = [ds.EntryDate]
  NullValue = <NULL>