detail section row height

[Guest]

I need to generate a report which will be 9 pages long but the detail section
runs out after 55.873cm.
Is it possible to alter the default height for the detail section please.

 

[Duane Hookom]

Check the thread "How many report pages for a single report" from Mike Lang
earlier today.

 

[Guest]

Thanks for your reply. Please could you explain more about your comment 'you
can create additional "detail" sections
be creating lowest level sorting and grouping levels on your primary key.
Display the header and/or footer sections of these new grouping levels.

To give you more background about what I need to do :
We have an existing database (which is only 1 table) and the originator no
longer works here so I've inherited it. Because the report is so long (and
has lots of additional label fields) the originator has created 9 different
reports then brought them together in a macro to print them individually.

Modern technology means e-mail is a better option than posting these printed
copies but to output 9 different reports using the existing means will give 9
separate attachments.

If it's not easy to create 1 single report, is there any means of outputting
the 9 individual reports into a single attachment to e-mail.

Many thanks for your help

 

[John Spencer]

One possible method might be to include each separate report as a
sub-report. It depends on the formatting you need.
A sub-report control's height can be .25 inches and its Can Grow property
can be set to Yes (TRUE). That will allow the sub report to expand to
whatever size is needed to print the sub report.

You could use a page break control (it's in the toolbar) after each
subreport to force a new page.

Another method would be to use Duane's suggested solution.

Select View: Sorting and Grouping
Add a Grouping level on your primary key (you may need to group on more than
just that, but this should give you the general idea)
Show Headers and Footers for the new Group
Close the dialog box

The Header and footer of the new grouping level you have added can each be
up to 22 inches high and can contain part of your report information.

At this point you have a potential of 66 inches of vertical space to work
with (22 inches in the detail section, plus 22 in the group header and
footer). You can add another 44 inches by adding another group level.

One problem you could run into is that a report or form is limited to 754
controls (labels, lines, text controls, etc) over the lifetime of the
report, so with nine pages you could hit that limit. Anadvantage of using a
sub-report is that a sub-report can have 754 controls. The sub-report's
control counts as only one control on the main report.

 

[Guest]

thats done it.
Many thanks for your help

One possible method might be to include each separate report as a
sub-report. It depends on the formatting you need.
A sub-report control's height can be .25 inches and its Can Grow property
can be set to Yes (TRUE). That will allow the sub report to expand to
whatever size is needed to print the sub report.

You could use a page break control (it's in the toolbar) after each
subreport to force a new page.

Another method would be to use Duane's suggested solution.

Select View: Sorting and Grouping
Add a Grouping level on your primary key (you may need to group on more than
just that, but this should give you the general idea)
Show Headers and Footers for the new Group
Close the dialog box

The Header and footer of the new grouping level you have added can each be
up to 22 inches high and can contain part of your report information.

At this point you have a potential of 66 inches of vertical space to work
with (22 inches in the detail section, plus 22 in the group header and
footer). You can add another 44 inches by adding another group level.

One problem you could run into is that a report or form is limited to 754
controls (labels, lines, text controls, etc) over the lifetime of the
report, so with nine pages you could hit that limit. Anadvantage of using a
sub-report is that a sub-report can have 754 controls. The sub-report's
control counts as only one control on the main report.