I am using a report with 5 tables of data and am having trouble with Null Values. The tables are named CLASS, FAILUREMARK, LABOR, LABTRANS, & WORKORDER. I have no trouble bringing in the data until I included this field {FAILUREREMARK.DESCRIPTION}.  If the field is Null, then the record will not show at all. I have the ‘Convert database NULL values to default’ in the options and report options. I have also reviewed several websites showing different ways to show Null records with the If-then-else statement.

My question is what would be the formula for this, and where do I place it. I am filtering records from the Select Expert section: {LABTRANS.REFWO} like ["4170936", "5622714"]. Do I create a formula with the If-then-else statement and place it somewhere on the report, or can this be placed in the same Select Expert formula listed above.

All of the links are set to INNER JOIN, except for the FAILUREREMARK table, which you mentioned to make LEFT OUTER JOIN. All of the table links are NOT ENFORCED.

I am pulling this data out of an ODBC database, to which I can see the tables and records. In the Crystal Report, I am filtering the report to show only two records from the {FAILUREREMARK.DESCRIPTION} field, which in the ODBC database, I can see one is populated, and the other one IsNull.

As soon as I pull the {FAILUREREMARK.DESCRIPTION} out of the Crystal Report, both records appear, but when it’s added, the one with the populated field is the only one that shows up.

Thanks for your help. Unfortunately, I will have to work more on this tomorrow. Thanks again.