There is a problem that affects Crystal Reports when you query a field that contains null values. A null value is an entry given to a field when there is no data. It is different from zero or from a blank.
For instruction to work around the null value problem in Crystal Reports visit the Crystal Reports null value page.