1212306 - Null Records are not shown when Record Selection is done on a Child Table

Creating a new report using the native drivers to connect to Microsoft SQL Server where two tables are joined using a left outer join, refreshing the report will only return records that have matching values in the record selection.  

Viewing the fields displayed you can confirm that the fields that are equal are displayed but the null values from the child table are not being displayed using the left outer join.

NOTE:=====

To view the join type being used in a report select "Database", "Visual Linking Expert" and right click on the join line. You will have "Options" available from the shortcut menu which will display the join type.

===========

CHILD TABLE LEFT OUTER JOIN RECORD SELECTION WHERE CLAUSE Seagate Crystal Reports Microsoft SQL Server, Oracle, DB2, Informix, Sybase StarEquals Null Records and Record Selection , c2007149 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem