Print a '0' in Count if no records returned 1

[JBourne77]

I am confused, thus this post. I am doing a count on a field and there are some that will have zero as a count. I set my count to show the value as a "0" but its just printing blanks. Any help is appreciated.

Right Click >> Format Field > "Custom Style" > "Show Zero Value as:" = 0

 

[lbass]

Try replacing the summary with a formula:

if isnull(count({table.field})) then 0 else
count({table.field})

-LB

 

[JBourne77]

lbass,

I tried:

if isnull(count({aaVisitStatus;1.TicketNumber})) then 0 else
count({aaVisitStatus;1.TicketNumber})

and I get back a sum of all my Bill Status codes versus a count per bill status code - ({aaVisitStatus;1.code}). I think I need to tweak this some.

 

[chelseatech]

Check you haven't set the Report Option for "Convert Database NULL values to default" or "Convert other NULL values to default"

These are specific to each report and you can set them via File/Report Options

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[JBourne77]

chelseatech -

Those were both unchecked.

 

[lbass]

You need to add the group condition--didn't know you had one:

if isnull(count({aaVisitStatus;1.TicketNumber},{aaVisitStatus;1.code})) then 0 else
count({aaVisitStatus;1.TicketNumber},{aaVisitStatus;1.code})

-LB