Configuring a report's custom page size?

[StargateFan]

Is this possible to do? It's all well and good to say one will print
so many reports on a given page size, but I'll run into the stumbling
block I've come to realize that that wouldn't mean the individual
reports printed on those pages will come out the desired size if
they're set at a standard 8.5 x 11 page size. Instead, I'm hoping
that by configuring the total report size to be the target size I
need, that printing x-number of these on an 8.5x11" page will still
have the individual reports conform to that individual size. But I
haven't a notion on how this report size configuration would be
handled. If anyone knows, pls pls advise.

Thanks so much. D

 

[Vincent Johns]

Is this possible to do? It's all well and good to say one will print
so many reports on a given page size, but I'll run into the stumbling
block I've come to realize that that wouldn't mean the individual
reports printed on those pages will come out the desired size if
they're set at a standard 8.5 x 11 page size. Instead, I'm hoping
that by configuring the total report size to be the target size I
need, that printing x-number of these on an 8.5x11" page will still
have the individual reports conform to that individual size. But I
haven't a notion on how this report size configuration would be
handled. If anyone knows, pls pls advise.

Thanks so much. D

I'm not sure what you're trying to do here. It appears that you have
several small reports (but I suppose there can't be very many of them)
that you want to fit onto a single page of printer paper.

If the material for one such report can be expressed in a Query (perhaps
as a Crosstab Query), you might find it helpful to use MS Word's "Mail
Merge" function to display the results. That would give you lots of
freedom in formatting the reports, and you could put several onto one
page. For examlpe, think of a page of mailing labels -- you might even
use a mailing-label template as the basis for your report.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.

 

[StargateFan]

I'm not sure what you're trying to do here. It appears that you have
several small reports (but I suppose there can't be very many of them)
that you want to fit onto a single page of printer paper.

If the material for one such report can be expressed in a Query (perhaps
as a Crosstab Query), you might find it helpful to use MS Word's "Mail
Merge" function to display the results. That would give you lots of
freedom in formatting the reports, and you could put several onto one
page. For examlpe, think of a page of mailing labels -- you might even
use a mailing-label template as the basis for your report.

One of the target reports can come out as a small booklet that we
stape together, that's the goal in asking this question. I thought of
using some sort of label size but even 5163, also with its incorrect
orientation, would be too small. But perhaps this could be approached
as a "custom label" type of thing? I'll look into this.

The majority of the other reports will be regular-sized, it's just
this one needs to be like a small carry-around guide with some of the
info from the db.

Thanks. I'll investigate later today when I'm at the office where the
db is. D

 

[Vincent Johns]

StargateFan wrote:

[...]

One of the target reports can come out as a small booklet that we
stape together, that's the goal in asking this question. I thought of
using some sort of label size but even 5163, also with its incorrect
orientation, would be too small. But perhaps this could be approached
as a "custom label" type of thing? I'll look into this.

The majority of the other reports will be regular-sized, it's just
this one needs to be like a small carry-around guide with some of the
info from the db.

Why don't you start with 5163, save it under a new name, and reformat it
to fit your needs? It sounds as if it's close to what you want, just
not quite big enough. You could delete a row or column of labels and
make the remaining ones bigger, to fill the available space.

When I've done this, I've run into problems with page margins, as many
printers won't print edge-to-edge on the paper. So you may need to make
creative use of paper cutters, or apply similar margins along the
internal borders of your forms (the labels).

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.