Printing a Null set of records

[agreen10]

Can anyone help me with printing a null set of records. for example. I would like to print the records for students who did not have any grades entered at all. I managed to create the report with left outer joins which gave me everyone but I only need to see those who did not have any scores entered.

 

[lbass]

Assuming the grades are in a separate table, with a left join from the student table to the grades table, you would first insert a group on {table.student} and then create a formula {@grades}:

if isnull({tableB.grades}) then 0 else 1

Then go to report->edit selection formula->GROUP and enter:

sum({@grades},{tableA.student}) = 0

-LB

 

[Madawc]

If you just want to print those without an entry for grade, then use section-suppress.

Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for suppression. Enter a formula; e.g.

 isnull({grade.tot}) or {grade.tot} = 0

I'm allowing for an entry which is there but has no meaningful values: most datasets have them.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10