Suppress Null Date to display

UltramanUltraman
edited 1:42PM 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 1:42PM

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


  • inetMarkinetMark
    edited 1:42PM
    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 1:42PM
    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 1:42PM
    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.
  • maxhugenmaxhugen Australia
    edited 1:42PM
    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 !
  • StarkStark Syria
    edited 1:42PM
    You could Add Expression to replace the date string '01-01-0001' to Empty string.

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

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport .NETComment As ...

© Vanilla Keystone Theme 2024