How do I  produce a report that lists master-items and its related sub data
from two subsets on a single sheet.

My environment is
* Delphi 1 and Delphi 3
* Quick Report 2.0h
* MS SQL-server 6.5
* NT4 WS

Data model

Educations   -   Person   -   Employments

The model lets me represent the history of educations and employments for a
number of persons.

Tables and fields

Person
        PersId
        Name
Educ
        EducId
        PersId
        EducStartdate
        EducEndDate
Emps
        EmpId
        Persid
        EmpStartDate
        EmpEndDate

I wish a output on a QuickReport-report with this layout, or something like
it:

Bobby Broun

Educations                                      Employments
Highschool      1984-08-23 -- 1986-06-03        Bookstore       1983-10-10 -- 1983-12-23
University      1988-08-29 -- 1991-05-21        MDG             1986-05-10 -- 1986-11-10
                                                {*word*110}tore       1986-11-11 -- 1988-08-28

Elisabeth Green

Education                                       Employments
xxxxx   yyyy-yy-yy -- zzzz-zz-zz                xxxxx   yyyy-yy-yy -- zzzz-zz-zz
xxxxx   yyyy-yy-yy -- zzzz-zz-zz                xxxxx   yyyy-yy-yy -- zzzz-zz-zz
xxxxx   yyyy-yy-yy -- zzzz-zz-zz
xxxxx   yyyy-yy-yy -- zzzz-zz-zz

Paul Yellow
.
.
.

My SQL till now is a simple join of the three tables, sorted on
person.namn, person.persid. I have succeeded in making two reports:
* an education - report
      and
* an employment - report
But not a single report that gives both of them in the same paper sheet.

My questions right now are:
* Is it possible in Quick report to create this output?
* Bo I need a more complex SQL?
* Do I need more than one dataset in the report?
* Can a group band have more than one detail band?
* Can a report have more than one groupe band?

If you have any clues, please send a mail to [clare...@algonet.se].

Thanks in advance

Clarence