How do I get a report to include classes with 0 enrollments?

[timothy.oconnor_2]

I successfully created a report that provided a list of open classes and the the number of student registrations. However we need the report to include 

all active classes (even the ones that do not have any enrollments as of yet) Seems the report I created only lists the classes with active enrollments 

and omits the classes with 0 enrollments. Is there a way to have the report list all open classes even the ones with 0 enrollment activity? 

Thanks in advance for any guidance. 

- Tim

[Tom C]

User a left outer join to display all classes in this crosstab report even for the class that has no student registration.

select .......from class_table cleft (outer) join on registration_table r where c.classid = r.classid[/code]