Grouped "Sub-Report" in report header

[robinpearce]

Have you any ideas how I produce the following report. I have tried numerous things and can not seem to come close
A simplified example of table tructure is shown below, together with the report requirements.



1. EmployeeJobs (view) : with Employee_id, Employee_Name and JobDescription
This view will have many rows per employee, where each row contains a job they have held
2. QualificationCategory : with ID and Description
3. Qualification : with ID, Description and QualificationCategory_Id
4. EmployeeQualificationLinkTable : with Employee_Id and Qualification_Id
This table indicates what qualifications each employee has, they may have many or none

The requirement is to produce a report grouped by Employee showing all the jobs they have held.
However, in the header for each employee they want to see a list of qualifications the employee
has held, grouped by Qualification Category, something like

Employee : FRED
===============
IT Qualifications
-------------------
Programming Qualification
Sun JAVA Certified

Other Qualifications
-----------------------
X
Y

Programmer
Support
IT Consultant

In this example FRED would have 3 rows in EmployeeJobs for "Programmer","Support" and "IT Consultant".
There would be 4 rows in EmployeeQualificationLinkTable for "Programming Qualification","Sun JAVA Certified","X" and "Y".
These 4 qualifications belong to 2 different categories - "IT Qualifications" and "Other Qualifications".

My apologoes this is such a nasty requirement - silly customers.


Best Regards
Robin

[robinpearce]

OK : Don't worry about this question. I have manager to resolve it.

I wrote a sub-report to show the qualifications by category. What I did was

Wrote the qualification stuff as a sub-report by positioning it at the top of the main reports databand. It had to be here in order that I could set the Master Component within the sub-reports databand. .i.e link the sub-report back to the main report.

What I then did was to make the sub-report visible & non-visible at the correct moments by using the print events on the report components, in order that the sub-report only printed at the start of each employee

Thanks
Robin