Suppress Null Date to display

UltramanUltraman
edited 8:11AM in FastReport .NET
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

Comments

  • pinbotpinbot Texas
    edited 8:11AM

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


  • inetMarkinetMark
    edited 8:11AM
    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.
  • inetMarkinetMark
    edited 8:11AM
    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.
  • sokacsokac
    edited 8:11AM
    inetMark wrote: »
    show previous quotes

    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.
  • maxhugenmaxhugen Australia
    edited 8:11AM
    sokac wrote: »
    show previous quotes

    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 !
  • StarkStark Syria
    edited 8:11AM
    You could Add Expression to replace the date string '01-01-0001' to Empty string.

  • ericchuaericchua
    edited 8:11AM
    Stark wrote: »
    You could Add Expression to replace the date string '01-01-0001' to Empty string.
    TRY THIS
  • ericchuaericchua
    edited 8:11AM
    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

Leave a Comment


Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2025