[RESOLVED] [2005] Crystal Report Multiple Tables, need help
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
Re: [2005] Crystal Report Multiple Tables, need help
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.
Re: [2005] Crystal Report Multiple Tables, need help
Quote:
Originally Posted by 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.
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....
Re: [2005] Crystal Report Multiple Tables, need help
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.
Re: [2005] Crystal Report Multiple Tables, need help
Quote:
Originally Posted by 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.
Thats exacltly what i need.
Thanx rasinc
:wave:
