Reports - SubReports and Grouping

[John P]

Hi all

I am trying to create a report which accurately replicates a standard form, so layout is critical.

The required report will be multiple pages, each (Landscape) page must be split horizontally into two sections, upper and lower.

The top section displays information on four records and the lower section is required to display more info on the same four records. This pattern should then repeat over all records, approx 80.

eg.
TOP SECTION
1. NAME ADDRESS WAGES ETC ETC
2. NAME ADDRESS WAGES ETC ETC
3.
4.

BTM SECTION
1. POSITION CERTIFICATE CERT DETAILS ETC
2. POSITION CERTIFICATE CERT DETAILS ETC
3.
4.

I have managed to create two forms that replicate the required top and bottom section, and using grouping on an autonumber ID with interval set to 4, I have almost managed to limit the records on each form to four, unfortunately the first page gives 3 !

I cannot however get both forms to work on the same form, I have tried many combinations of using unbound forms as containers for two subforms, using groups to insert one form into another, but after 5 solid hours I'm just about ready to concede defeat!

Any help appreciated
JP

[John P]

Appologies for the somewhat incoherent post above!

It was getting pretty late / early!

I have only endeavored to solve the problem using reports, ie utilising one report as the main report and then adding the second report as a subreport in the group footer section. Also using a non-bound report as a container and placing the two reports within this container, I have tried various combinations of inserting in the detail section, group header, footer etc, but all combinations give rise to problems in formatting or record selection.

I'd love to fininsh this project this week if poss.

Any help appreciated
JP

[NeoPa]

Well JP, I'm not sure if I can help very much as I don't have much experience with this sort of thing.
What I'd try though, is to design a report with space in the detail section for TWO subreports. The subreports would show the different data that you require, and would be sized to show exactly four records max (each).
I can't easily test this out, but it seems logically that it should work.