Count with null values
Posted on 2003-10-21
In the report I have a count of a fields that can be null (I use LEFT OUTER JOIN in SQL).
When I created all my reports, Crystal Reports gave zero for the count when all values of the field are null.
But now, using RAS or installing Crystal Reports in other PCs, the result (in the same reports) for the count is null when all values of the field are null.
I have tryed selecting "Convert another NULL values to predeterminated" in Report Options, but it only works with summary fields, not with summary in crosstabs. I use a lot of crosstabs in my reports.
Which is the option I have to select in my PC so I get zero with the count of null values?
I know I can get zero using a formula instead of using a summary count, but I have a lot of reports. So I would prefer knowing why Crystal Reports works different in my PC, instead of modifing all my reports.
Thanks in advance. Regards