print the first page only

[markjkubicki]

i have a report that has its page numbers subdivided by report sub-grouping;


so, i might have something like this:

group A, page 1 of 3, 2 of 3, 3 of 3
group B, page 1 of 1
group C, page 1 of 4, 2 of 4...

how would i go about having ony the 1st page of each group print?

each page of the report is a single image, and the record source table includes the image hyperlink, a numeric field that determines what order the images print in, and a logic field that states whether to print the record or not; i had erronously written for the code to print images indicated to be page 1, but there are instancees, where they may not be a page 1 ( page 1 may have been deleted or the user may have simply skipped it and started their sequence at a differnt number...), or page 1 may be flagged not to print ...the first page to print might be page 3

thanks in advance,
mark

[June7]

Open the report in PrintPreview filtered to single group, print page 1, close report, open filtered to next group, etc.

This can be automated with VBA code.

[markjkubicki]

i amy be reading this wrong... but won't this result in a series of individual reports (vs. a single report with the 1st page (only) of each group) ?

[June7]

That is true. I don't know any other way to accomplish what you need other than to somehow restrict the report to retrieve only the one record for each group.

[markjkubicki]

hmpt...
i wonder if i could code something that checks if the page number (in the group) is > 1, and if so... bumps me out of that group, and into the next, with out printing that or any subsequent pages in the first group ??

[June7]

I have doubts. Can open report in PrintPreview, click Print to open the printer dialog and select a range of pages to print but can't seem to skip and pick pages like: 2,4,7,12. So I doubt can be programmed.

The report doesn't 'know' that groupZ has x number of pages. You would have to calculate that. However, since I don't think multi-range page selection can be programmed this is irrelevant.

http://office.microsoft.com/en-us/ac...001226272.aspx

[markjkubicki]

( already am calculating the number of pages in each group for a footer that includes: "page # of #" ) .