Maximum height of report is 22 inches

Y

Yair Sageev

I am running out of space for the layout that I want. Is there any way to
add more height to a report?

Thanks
 
M

Marshall Barton

Yair said:
I am running out of space for the layout that I want. Is there any way to
add more height to a report?

No!

I find it hard to imagine a report with a single section
anywhere near that long. Either you are suffering from a
misperception of how to design a report or you have an
extremely unusual situation.

Maybe you can place some of the controls in a subreport??

Maybe you can make some/many/all of the controls shorter and
set their CanGrow property to Yes??

Maybe you can move some of the controls to a Header and/or
Footer section??
 
Y

Yair Sageev

Marshall Barton said:
No!

I find it hard to imagine a report with a single section
anywhere near that long. Either you are suffering from a
misperception of how to design a report or you have an
extremely unusual situation.

I got a lot of stuff on the page! [cringe]

The report has to show all related information in the database keyed by a
single id. Right now there are about 1 dozen subreports + 1 subreport with
6 subreports. A report itself is just a bunch of pages, so why should there
be a height limitation? It's sort of like Word having a three page limit to
documents. I guess I could resize the subreports to have very little
height, but then their contents would not be visible when I try to edit
them. That would get around the problem, but would be inconvenient.

Maybe I am suffering from a misperception about report design which you can
correct.

Much thanks. :)
 
M

Marshall Barton

Yair said:
I got a lot of stuff on the page! [cringe]

The report has to show all related information in the database keyed by a
single id. Right now there are about 1 dozen subreports + 1 subreport with
6 subreports. A report itself is just a bunch of pages, so why should there
be a height limitation? It's sort of like Word having a three page limit to
documents. I guess I could resize the subreports to have very little
height, but then their contents would not be visible when I try to edit
them. That would get around the problem, but would be inconvenient.

Maybe I am suffering from a misperception about report design which you can
correct.

Possibly, but your situation does sound unusual.

In addition to making the controls shorter, another possible
way around this is to use additional sections. Add a
Sorting and Grouping level (View menu) using a constant
expression such as =1 and set it's Header and Footer to Yes.
You can then spread your controls out across all three
sections. Add more groups the same way to get even more
headers/footers. You can get up to 200 inches of design
space this way. One advantage of using multiple sections in
your type of situation is that you can take strategic
advantage of each section's ForceNewPage and KeepTogether
properties, which might be crucial for this report.

If you have data for only one entity, you might be able to
spread controls onto the report header and footer too.
 
Y

Yair Sageev

Thanks, both of you, for the help.

.....
In addition to making the controls shorter, another possible
way around this is to use additional sections. Add a
Sorting and Grouping level (View menu) using a constant
expression such as =1 and set it's Header and Footer to Yes.
You can then spread your controls out across all three
sections. Add more groups the same way to get even more
headers/footers. You can get up to 200 inches of design
space this way. One advantage of using multiple sections in
your type of situation is that you can take strategic
advantage of each section's ForceNewPage and KeepTogether
properties, which might be crucial for this report.

I'm not sure I understand this grouping thing. Will research it some more.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top