Fixed number of data lines in a report

  • Thread starter Thread starter Ryan T
  • Start date Start date
R

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.
 
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.
 
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
 
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.
 
Thanks!

Allen Browne said:
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.
Click to expand...
 
Back
Top