Kbase P101410: Crystal Reports 'Left Outer Join' is not returning all the expected records.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/21/2005 |
|
Status: Unverified
FACT(s) (Environment):
Windows
Progress 9.1D
Crystal Reports 10
SYMPTOM(s):
Crystal Reports 'Left Outer Join' is not returning all the expected records.
Table A does a "Left Outer Join" to Table B.
Selection Criteria of records on Table B is based on user provided parameters.
Query is only returning the records where there is a match from Table A to B.
Records from Table A are returned when the SELECT statement on table B is removed.
Use the ISNULL function at the beginning of the table B selection criteria:
(ISNULL({tableB.Year}) OR {tableB.Year} = {?Pyear})
CAUSE:
Syntax error: The select statement on table B: {tableB.Year}, did not provide for the ISNULL values.