K
Kurt Monroe
I have a report that does a page-break based on either a new row in its
Record Source or when either of its subforms overflow the details section.
So, one row in the underlying query may cause multiple pages in the report,
depending on how big the subforms get to accomodate the data.
I'm using the "insert, page numbers" pull-down to put "Page n of n Pages" on
the report, and that works fine. But I need to make that part behave a little
different.
I want to have "Page n of n pages" accumulate and reset based on a new row
in the Record Source.
So at the bottom of each page, I want it to read "page x of y pages" where
both x and y change when there's a new row in the underlying query. Value x
would accumulate for each page, and y would somehow be determined at
run-time, like it works for total pages in the whole report, except another
level, reseting for each new row. I can't calculate it in the query since I
don't know if the details section will overflow, at least I don't know who to
figure it out.
My work-around is to break up the report into multiple reports and run it
many times, "behind the scenes", that would cause it to print with the
correct page numbers, but I wouldn't be able to show them a "Print Preview"
of them all, it would do it one at a time, which I don't want. I want them
to see a Print Preview of the whole report, not multiple Print Previews,
because it could end up being 50 Print Previews for them to struggle through
(I send them to Print Preview so they can review it before printing)
Is that possible?
Thanks,
Record Source or when either of its subforms overflow the details section.
So, one row in the underlying query may cause multiple pages in the report,
depending on how big the subforms get to accomodate the data.
I'm using the "insert, page numbers" pull-down to put "Page n of n Pages" on
the report, and that works fine. But I need to make that part behave a little
different.
I want to have "Page n of n pages" accumulate and reset based on a new row
in the Record Source.
So at the bottom of each page, I want it to read "page x of y pages" where
both x and y change when there's a new row in the underlying query. Value x
would accumulate for each page, and y would somehow be determined at
run-time, like it works for total pages in the whole report, except another
level, reseting for each new row. I can't calculate it in the query since I
don't know if the details section will overflow, at least I don't know who to
figure it out.
My work-around is to break up the report into multiple reports and run it
many times, "behind the scenes", that would cause it to print with the
correct page numbers, but I wouldn't be able to show them a "Print Preview"
of them all, it would do it one at a time, which I don't want. I want them
to see a Print Preview of the whole report, not multiple Print Previews,
because it could end up being 50 Print Previews for them to struggle through
(I send them to Print Preview so they can review it before printing)
Is that possible?
Thanks,