Reports

[DRBE]

I am busy developing a database to automate the process of making
appointments for seeing clients / sending appointment letters / capturing
information when I see them.
This is all working OK.
I am now trying to develop reports
1) for the appointment letter. This works fine, except with the
questionaire included it will be 7 pages (only the 1st 2 need the database to
add client name etc. When I try to develop the report, by the 3rd page, it
won't let me continue. (I used the "insert page break" in the report to
separate into the next page.
The max document length for the report appears to be 55cm (which amounts to
2.5 pages.). how do I create a longer document.

2) the 2nd report, produced to summarise the interview will be about 14
pages, and will be data drawn from the database throughout, so will clearly
need to be longer than the current 2 pages. how do I make it allow a longer
report.

 

[John Spencer]

You might do better to use automation and have the reports generated using
automation and word.

Al Kallal has an example for doing this at

Word Merge Code

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

A report Section is limited to 22 inches (56 cm) in height
A report is limited to 200 inches (508 cm) in height
A sub-report put onto a report can grow.

SO,
Add a group to your report based on the primary id and put some of your
controls in the group header and footer and some in the details section.
You can add another group based on the primary id to get an additional 44
inches of print space.

So with two group headers, two group footers, and a detail section you
should be able to get 110 inches of printing space.

Another option is to sub-divide your data into some sub reports and then set
the height of the sub-report controls to .5 inches or less with a page break
control between each sub-report. Turn on Can Grow for the sub-reports and
the section containing the sub-reports.

Hopefully this will give you some ideas on overcoming the 22 inch (55 cm)limit
of a
section in a report.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County