Code:Hi,
I am trying to use a crosstab to fill a report of student and grades.
My basic query looks like this:
select class_name,
student_name,
module_name
where ...
...
order by class_name,
student_name,
module_name
I am grouping by class_name, so when the students are doing the same subjects the report is correct and
looks like:
ModuleA ModuleB ModuleC
Jim P M P
Sally F D F
My problem is when a student is not doing one of the module, for example Jim is not doing ModuleB. The results
look like
ModuleA ModuleC ModuleA ModuleB ModuleC
Jim P P
Sally F D F
This isn't correct, I want only a blank where they are not doing that module.
Is there a way to do this with jasper, or do I have to change the SQL to have an outer join?
Any ideas?