Question on missing data

[MiagiSan]

CR 10
SQL

Hello,

I am pulling data from my CRM ticketing system to show me the following data:

Case# Name Company Status Summary Solution
12345 Jsmith ACME Closed xxxxxx xxxxxx
54321 Rsmith IBM Closed xxxxx xxxxx


The issue I am having is that if the case is still in an "Open" status, there is no solution. As a result, none of the open cases are showing up in my report. If I remove the Solution field from the report, the Open cases show up.

What I want to see is this:

Case# Name Company Status Summary Solution
12345 Jsmith ACME Closed xxxxxx xxxxxx
43256 REastman Pepsi Co. Open xxxxxx
54321 Rsmith IBM Closed xxxxxx xxxxxx


I checked the FAQ on this site regarding blank and Null values but did not find anything that I was able to use. If an open case has no solution, nothing has been written to the solution table for this case. does this mean it is neither a Null or blank value?

My record selection is based only on a date range.
Joins are all left outer joins

Thank you for the help; please let me know if I have left any information out.

R

 

[raja2008]

When you said left outer join ,make sure outer join is on the case table.
That's all i can think of.

 

[lbass]

The left outer join should be FROM the table containing the bulk of the records TO the solutions table, and there can be NO selection criteria on the solutions table (unless you use a command as your datasource, and insert the criteria in the join language in the "From" clause).

-LB

 

[MiagiSan]

That did it!!

Thank you very much!!

R