Generating report in Access

Y

Yue Zhao

Is there a limit of length of the report? I can't make it longer than 21
inch... :(
 
Y

Yue Zhao

No. I have been breaking the report into pages of letter size, using the
page break. But the "detail" part of the report can't be enlarged any
more after 21 inches.
Is there any suggestion about that?
 
D

Douglas J. Steele

It's a hard-and-fast limit. You can get around some of the length issues
using subreports, but you're pretty much stuck for width.
 
J

John W. Vinson

Is there a limit of length of the report? I can't make it longer than 21
inch... :(
Click to expand...

The limit (including margins, I believe) is in fact 22 inches. I believe you
can stretch it some by using Subreports.

John W. Vinson [MVP]
 
L

Larry Linson

John W. Vinson said:
The limit (including margins, I believe) is in fact 22
inches. I believe you can stretch it some by using
Subreports.
Click to expand...

But, to the original poster... you can put more information than a human can
grasp into a 22" X 22" space. It would appear to me that you have a problem
in how your data itself is structured, or how your presentation of the data
is structured.

Years ago, in another incarnation, I was supporting a Project Management
Software package. One of our Sales Tech Support people sent us a question
from his customer: "Can the product support a project of 400,000 tasks?" My
response was, "No, the product limited to 32,767 tasks, but 32,767 is more
tasks than a human could grasp, follow, and understand. However, the
product has very nice features for breaking down into groups or subprojects
that a project manager can grasp, and consolidating the results into an
overview that corporate management can grasp and understand."

I suspect a similar answer may apply here.

Larry Linson
Microsoft Access MVP
 
Top