Trying to get a Report to print fields with blank data

[agreen10]

I have a report using crystal 10 where I am trying to print out schools who have not turned in student grades. I am only getting the schools that have turned in something. I really want the opposite. Can anyone help me?

I am using three tables to get the data example:

grades:
eng
math
for
sci

schools:
School name

students:
names

 

[Turkbear]

Hi,
What database?
What linking between the tables?
What selection criteria?

In general, you probably need to use Left-Outer Joins..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[agreen10]

Sorry for leaving that out. I am using a mysql database and the student table is linked via a student id to the grades table and the sites is linked to the student table via a site id field.

Hope that helps. I will try the left outer joins in the mean time.

 

[lbass]

Try a left join FROM the school table to the student table, and FROM the student table to the grades table. Then create a record selection formula of:

isnull({grades.studentid})

-LB

 

[agreen10]

I tried that and received no records.

 

[lbass]

Did you place the school field in the details section? Please explain exactly what you did.

-LB

 

[agreen10]

I created the joins you gave above and yes, the school field is in the details section but the report returns no records.

 

[agreen10]

Thank you very much, I did a seperate report with what you told me and it worked. I had the joins turned incorrectly.

Thanks again.