not all records showing on report 2

[maggielady]

I have a report that has multiple fields from a family dbf. I have the report grouped by lastname and sorted on lastname. There are 30 families in the dbf. But when I run the report only 27 families show up. After looking at it the families that aren't showing have one or more of the fields blank that are on the report. How do I get these families on the report if one of their fields are blank?

 

[dgillz]

Try file, options, reporting tab, and make sure the "convert null field values to default" checkbox is checked.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[Madawc]

Alternatively, you could create a formula field that tests for null and notes it as such, perhaps with some other identifier so that you know which 'family' it is. Then group using the formual field.

I prefer to leave null on, because it tells you something distinct from spaces or zero. Zero means you know that there is nothing, whereas null means you don't have that data.

Remember that a test for nulls must always be done first, Crystal's design philosophy is that formula fields will produce no output for a null unless you specify output. Whereas division by zero stops the report with an error message, that's the way they choose to see it.

Madawc Williams
East Anglia
Great Britain