Hey there,

I have a summary field in my report to return a DistinctCount of the number of "orders" in a specific "job group." But sometimes if there are no orders in a specific job type, it will not return any result. I would like it to give a result of "0". I've killed myself working with the ISNULL functions and whatnot, but can't seem to figure out how to make the summary give me a number if there are null records.

My count code is called "COUNT 01":
DistinctCount({INSPECTION.INSP_ID}, {INSPECTION.INSP_STATUS_CODE})

When there are no INSP_ID 's for a specific INSP_STATUS_CODE, it shows nothing, but I want it to show zero.

I thought this would work:

If ISNULL({@COUNT 01}) then "0" else {@COUNT 01}
but of course it says I need a string for the last term.

What's a guy to do?

in the formula editor box there are two options "Exceptions For Nulls" & "Default Value For Nulls", and i am sure the option selected by you is "Exceptions For Nulls" , change  it to "Default Value For Nulls", you may get 0 if a field or formula is numeric and the data is null. This depends upon the value u have set in your crystal report for nulls. But by default for a numeric field or numeric formula the null value will be 0.

Yes, Dell i agree with you