dbcalc blank when zero
I have created a count() dbcalc, and would like it to show zero when the
count is zero!! (revolutionary, I know)
I have turned OFF the "Blank when zero" option, but it still uses that
format. I have also looked at the DisplayFormat option, but I only want to
force a single digit.
Is there something I'm missing? Thanks for any advice.
count is zero!! (revolutionary, I know)
I have turned OFF the "Blank when zero" option, but it still uses that
format. I have also looked at the DisplayFormat option, but I only want to
force a single digit.
Is there something I'm missing? Thanks for any advice.
This discussion has been closed.
Comments
In my quick testing with RB 10.07, the DBCalc component does display zero if
the BlankWhenZero property is set to False and there are no records to be
counted. Which version of ReportBuilder are you using? Is anything showing
up when there is no data returned? Be sure you have your NoDataBehaviors
property set to ndBlankReport so your report components will display if
there is no data.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com