[RESOLVED] [2005] Crystal Report Multiple Tables, need help

[muzaffarhabibi]

Hi all, im still new in CR Reporting.
I've made a report that display profile of an employee. The report shows
the detail of the employee (from table employee). There are another 3 tables
included in the report. The education table, children, and job_experience (all linked to the employee table with the field employeeid).

Now im placing it all in the details section. So it will shows 1 record of education, 1 child and 1 job_experience.
How do I arrange it so it will show all details of education and then all details of children and all details of job_experience, not mixing?

I really appreciate the helps......

Thanx

[rasinc]

Right-click the details section label at the left and Add a new section below. This will give you a Detaials A and Details B and you can put one part in A and the second part in B. Add another section for the third.

[muzaffarhabibi]

Right-click the details section label at the left and Add a new section below. This will give you a Detaials A and Details B and you can put one part in A and the second part in B. Add another section for the third.

Thats what i've been doing. But the problem is, it doesnt look good. Let say there are 3 records of education, 3 records of children, it will mix. For first record, it will show education,
children, then education again, and children again, and so on.

Is it possible to make one section for one table? So the report will shows all education details, and only after it finished, it will show the children details, not mixing.

Thanx in advance....

[rasinc]

Create a subreport for each table Education, children and experience and put each one in a different Details section and link back to the employee table via the employee id number. This way all the records for each will stay together in a separate section.

[muzaffarhabibi]

Create a subreport for each table Education, children and experience and put each one in a different Details section and link back to the employee table via the employee id number. This way all the records for each will stay together in a separate section.

Thats exacltly what i need.
Thanx rasinc