Length of 'detail' are in report

[Guest]

I created a report with 2 grouping levels, as follows:

- Borrower - name, address, etc. - prints at the top of the first page for
each borrower report
- Loan # - Loan #, loan amount, loan date, etc. - prints at the top of
each page for each loan.
Detail - As it says, detail on each loan - this is a multi-page area
with 5 segments. I have inserted page breaks so that each segment will print
on a separate page (with each page showing the loan # info)

Thus, when I print it the first page has the borrower info, then the loan #
info then the detail, and the second page has the loan # info then more
detail on the loan - as it should.

Here's the problem: When I expand the detail area in design view to where
it is longer than one page, the first page has the borrower info only, the
second page has the loan # info and the detail, with each segment printing on
separate pages. How do I get it to stop "inserting" all that blank space on
the first page? It does not create a blank page - I had that problem and
fixed it. Other than that blank space on the first page, the rest is OK.
Any thoughts would be appreciated.

 

[Allen Browne]

I don't think the page break controls will work in the way you expect.

Instead, add new *sections* to the report, one for each page. You can tell
Access to print each of these sections on a different page, and so get the
results you want.

To do that:
1. Open the report in design view.

2. Open the Sorting And Grouping dialog (View menu).

3. Below the 2 grouping levels you already have, enter the name of your
primary key field. (This is the field that changes every time the detail
level changes.) In the lower pane of the dialog, choose Yes beside the Group
Header property and the Group Footer property. You should now see 2 more
sections on the report.

4. Repeat step 3 on the next row of the dialog, i.e. the 4th row will use
the same primary key field as the 3rd row, and you now have another Group
Header and Group Footer on the same row.

The end result is that you have 5 inner sections. Because these 5 change
with every detail record, you effectively have 5 detail sections.

By setting the ForceNewPage property of each of these sections, you can make
them appear on different pages. Drag the text boxes from your existing
detail section onto the appropriate places in the new sections. Remove the
page break controls. Reduce the height of your actual Detail section so it
fits on one page.

This trick of creating additional sections for the different pages in your
report is very useful where you have to match up the output of a report to a
particular layout.