Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

print blank instead of zero

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

  • 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




  • 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.