Left outer join and records filtering

[Former Member]

Hi All,

In the below example I'd like to join two tables on EmployeeId in a way that in the final result dataset I get EmployeeId where type equals A or is null. I'd be easy to do through command but I need to do it through table choice not command. When I left outer join the tables and filter records on condition type=A or IsNull(type) records with type value null are eliminated. Could you please advise how to do it?

Table 1

EmployeeId
1
2
3

Table 2

EmployeeId	Type
1	A
2	B
3

Result dataset:

EmplyeeId	Type
1	A
3

Regards,

Przemek

[abhilash_kumar]

Hi Przemek,

After you setup the Join in CR, go to the Report Menu > Selection Formulas > Record and use this code:

(IsNull({table.Type}) OR {table.Type} = '' OR {table.Type} = 'A')

-Abhilash