Problem with Displaying Multiple header data

[tpsiks]

Hi,
I have a problem with my report when the data reaches 2 pages, it will display the first header again and then continue with the next header.
Here's my scenario and data structure.
I have 3 TABLES. I'm using the main data for explaining purpose.

TABLE 1: Employee ID, Employee Name
Table 2: Empoyee ID, RecordType, SalesOrderNo
Table 3: Employee ID, Parts Used

This is my linking relationship:
Table 1 -->Table 2
Table 1 -->Table 3

Subreports:

Sub1 is using table 2
Sub2 is using table 3 that suppresses everthing BUT RecordType=0
Sub3 is using table 3 that suppresses everything BUT RecordType=1

Crystal Report 8.5 Grouping And Format:
Page Header
Group Header 1a:table1.EmployeeID::sub1
Group Header 1b:table1.EmployeeID::sub2
Group Header 1b:table1.EmpployeeID::sub3

Everything else is suppressed.

----------------------------------
Result:
If all my data fits one page it's okay. if 2 pages or more, it will display sub1 on everypage with one other sub report until the other 2 sub reports display all its data below sub1. I've tried moving all of them to detail a,b,c. It will display everything correctly until the end of the report and it will display it another 30 times of the same report. I've tried everything but it keeps on displaying multi record of the first sub report.

Any help is appreciated, sorry the mess of my explanations.

 

[lbass]

Go to report->group expert->options->and uncheck "repeat group header on each page".

-LB