I have set up a parameter field, however When I select the field it goes through about 15000 records then returns nothing, I believe my joins are correct.  My thoughts are I need to test for NUll maybe, I just don't know how to do this properly.

 

My SQL statement is as follows

 

 SELECT "STUDENTS"."FIRST_NAME", "STUDENTS"."LAST_NAME", "STUDENTS"."GRADE_LEVEL", "STOREDGRADES"."STORECODE", "STOREDGRADES"."TEACHER_NAME", "STOREDGRADES"."COURSE_NUMBER", "STANDARDSGRADES"."TRANSAVERAGESCORE", "STANDARDSGRADES"."STORECODE"
 FROM   ("PS"."STUDENTS" "STUDENTS" LEFT OUTER JOIN "PS"."STOREDGRADES" "STOREDGRADES" ON "STUDENTS"."ID"="STOREDGRADES"."STUDENTID") LEFT OUTER JOIN "PS"."STANDARDSGRADES" "STANDARDSGRADES" ON "STUDENTS"."ID"="STANDARDSGRADES"."STUDENTID"
 WHERE  "STANDARDSGRADES"."STORECODE"='T2'

 

The storecode is the filter I am trying to create, I am using an Oracle Database.  I am thinking I have blank or null values in the database so i am getting no results when it  hits the blank or null field.

 

Parameter is {STANDARDSGRADES.STORECODE} = {?Storecode}

 

Any help would be greatly appreciated!

 

Thank you

Shawn

 

This is where I am lost, maybe it is my join statements:

 

I have 3 tables

Students StoredGrades and StandardsGrades

 

Links

 

Students.ID ---Left Join enforce to = -->StoredGrades.studentID

                     |--Left Join enForce to = -->StandardsGrades.StudnetID

 

Now I believe the StandardsGrades table may or may not have Data, though I get the same results if I use a Right Join.