Maximum height of report is 22 inches

  • Thread starter Thread starter Yair Sageev
  • Start date Start date
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
 
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?
Click to expand...

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??
 
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.
Click to expand...

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. :-)
 
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.
Click to expand...

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.
 
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.
Click to expand...

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