Fixed number of data lines in a report

[Ryan T]

I created a report and need some help in figuring out how to fix the size of
the detail section. I need the section of the report that is populated from
my query to be the size of 22 lines of text (Arial size 7). When my query
has less than 22 lines the report automatically puts the report footer right
after the last line. Is there a way to fix the length of the details
section? Similarily I need a new page to begin after the 22nd line of data.

Thank you.

 

[Allen Browne]

You could make your report a subreport on another one. Then on the main
report, you can set the Height property of the subreport control or the
section that contains it, and set its Can Shrink property to No.

 

[Ryan T]

Hi Allen,
Thank you for the response. Setting the Height property fixed the are on my
invoice, but if there are more lines than the defined area, it creates a
scroll bar to view all of the lines of data. Do you know if there is a way
to start a new page if the lines of data exceed the fixed area size?

Thank you.

Ryan

 

[Allen Browne]

You should be able to set the height of the subreport control on your main
report so the desired minimum.

Then set its Can Grow to Yes, but Can Shrink to No.

 

[Ryan T]

Thanks!

You should be able to set the height of the subreport control on your main
report so the desired minimum.

Then set its Can Grow to Yes, but Can Shrink to No.