Data not showing up - Join Issue?

[MiagiSan]

Hello,

I am using CR X and I have 3 tables in my report.

TableA is left joined to TableB by {CASE_ID}
TableB is left joined to TableC by {SOLUTION_ID}
(TableB and TableC are solution tables)

Currently My data looks like this in my report.

Case ID Status Customer Solution
123456 Closed XYZ Solution 1
790101 Closed XXY Solution 2

If there is a case that is in a status of "Open" it does not have a solution and the entire line is missing from my report.

Here is what I want to see:

Case ID Status Customer Solution
123456 Closed XYZ Solution 1
790101 Closed XXY Solution 2
444689 Open XYZ

When I checked the DB, 444689 will show up in TableA>CASE_ID but not in TableA>CASE_ID like the other cases with solutions.

Do I need to use a union to resolve this problem or is it a join issue?

Thank you, I appreciate the assistance.

 

[IanWaterman]

The left outer joins should do it, so it looks like you have a filter condition in your select expert on data in tables B or C.

eg
Tableb.field = X

A way round this is to change to
(isnull(tableb.field) or Tableb.field = X)

Ian

 

[MiagiSan]

I am not sure if I am allowed to swear on this forum but...

Holy $hit, it worked!!

Thank you Ian

R