Home› Datapipelines
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

print blank instead of zero

rbuserrbuser
edited February 2007 in Datapipelines
My Query result in no record selected.

But TppDbtext print as blank instead of zero.
I want it prints zero, as per requirement.

How to do it ?

Comments

  • rbuserrbuser
    edited February 2007
    Sorry,
    Record exist and selected but field contain null,
    therefore TppDbtext contain null as well.

    How to print zero when the column/field contain null




  • nicociziknicocizik
    edited February 2007
    Hi Max,

    This is the designed behavior of ReportBuilder when encountering Null
    values. You can use the Band.BeforePrint or the DBText.OnPrint event to
    check for Null values then manually assign the value to "0" if it is.

    --
    Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.