R
Rob
I have a report that I must print on a pre-printed paper
form. It contains 4 sub reports. All look to the same
table for their records, but each group of records has
different criteria. Also, the first and second sub-reports
can contain ONLY 4 records each, because that is all that
the pre-printed form allows for. The 3rd and 4th
subreports can each contain ONLY 13 records each. If any
one sub-report goes over the limit of records, they will
print on an area of the form where they should not.
Example 1: If there are 6 records for the first sub-report
(which is toward the top of the page), I must use 2 of my
pre-printed forms, printing the first 4 records on the
first form, and the next 2 (2+4=6) on the second pre-
printed form. Example 2: If there are 40 records for the
3rd sub-report (which is in about the middle of the page),
I must use 4 of my pre-printed forms, printing the first
13 records on the first form, the next 13 on the second
pre-printed form, the next 13 on the third pre-printed
form, and the final 1 on a forth pre-printed form.
I have tried to use the method described in kb209006,
which incorporates PageBreaks set to invisible. When a
certain number of records are added, the page break is
made visible, and the next set of records moves to the
next page. This works fine when I open the report used in
the sub-report control, however, it does not work within
the Parent report when opened in the sub-report control. I
am very conversant with VBA.
Thank you for any help!
form. It contains 4 sub reports. All look to the same
table for their records, but each group of records has
different criteria. Also, the first and second sub-reports
can contain ONLY 4 records each, because that is all that
the pre-printed form allows for. The 3rd and 4th
subreports can each contain ONLY 13 records each. If any
one sub-report goes over the limit of records, they will
print on an area of the form where they should not.
Example 1: If there are 6 records for the first sub-report
(which is toward the top of the page), I must use 2 of my
pre-printed forms, printing the first 4 records on the
first form, and the next 2 (2+4=6) on the second pre-
printed form. Example 2: If there are 40 records for the
3rd sub-report (which is in about the middle of the page),
I must use 4 of my pre-printed forms, printing the first
13 records on the first form, the next 13 on the second
pre-printed form, the next 13 on the third pre-printed
form, and the final 1 on a forth pre-printed form.
I have tried to use the method described in kb209006,
which incorporates PageBreaks set to invisible. When a
certain number of records are added, the page break is
made visible, and the next set of records moves to the
next page. This works fine when I open the report used in
the sub-report control, however, it does not work within
the Parent report when opened in the sub-report control. I
am very conversant with VBA.
Thank you for any help!