B
BBN
I have a report that generates a phone list.
Each sales region is a separate page (page break in the
region footer.) The Regional manager's name at the top of
the page and the representatives for that region in two
columns below the RAM's information.
The problem with the report is that the first regional
manager's name & region # appears on the page for both
Region 1 and Region 2. This is the only record that is
duplicated and it pushes all the other regional managers
onto the next region's page. So manager 2 is on region 3's
page, manager 3 is on region 4's page, manager 4 is on
region 5's page, etc.
The manager and representatives information is kept in a
common associate database so two queries were developed;
one creates a list of Regional managers, the other a list
of representatives.
Since the regional manager's name & region # appear only
once on each page this info is generated by a subreport in
the page header using the manager's query, with the child
and master linked to region.
If the Regional manager subreport is run independently no
records are duplicated.
This is what a page of the report should look like:
Region # (aligned with the region on the page)
Regional Director (aligned with the region on the page)
multiple Sales Representatives (sorted by region/in two
columns)
Each sales region is a separate page (page break in the
region footer.) The Regional manager's name at the top of
the page and the representatives for that region in two
columns below the RAM's information.
The problem with the report is that the first regional
manager's name & region # appears on the page for both
Region 1 and Region 2. This is the only record that is
duplicated and it pushes all the other regional managers
onto the next region's page. So manager 2 is on region 3's
page, manager 3 is on region 4's page, manager 4 is on
region 5's page, etc.
The manager and representatives information is kept in a
common associate database so two queries were developed;
one creates a list of Regional managers, the other a list
of representatives.
Since the regional manager's name & region # appear only
once on each page this info is generated by a subreport in
the page header using the manager's query, with the child
and master linked to region.
If the Regional manager subreport is run independently no
records are duplicated.
This is what a page of the report should look like:
Region # (aligned with the region on the page)
Regional Director (aligned with the region on the page)
multiple Sales Representatives (sorted by region/in two
columns)