All fields in report are empty when joining on NULL value

[former_member1092607]

The report looks great unless the shipping field is NULL. There is a field on the report that tries to join to another table based on the shipping field, and when it is NULL, then the entire report is blank.

I am designing this report in Visual Studio 2010 and I have the correct version of the Crystal runtime installed, so that's not a problem.

What I have tried:

1. I set "Convert database NULL values to default" and "Convert other NULL values to default" under Crystal reports-->Report-->Report Options

This did not work.

I want it to not attempt to join if the field is NULL.

Any help is appreciated.

Jeremy

[former_member1092607 · Accepted solution]

I fixed it by using a LEFT OUTER JOIN instead of an INNER JOIN. Thanks to this thread: