You can't. If there are more records (rows) than the size of the paper will
allow it will spill over onto the next page. The only options would be to
either reduce the number of of subreport records (you could set a maximum) or
to print the subreport on a seperate page or just set the can grow option to
= No.
Thanks for the response. What I have is a master report made up of several
sub reports. What is happening is one of my sub reports (that only has one
record or row showing) is being rolled over on the bottom of the first page.
So I get the column headings at the bottom of page one and the data showing
at the top of page two. I would like to keep the column headings with the
first line of data. If it rolls over after that so be it.
I probably should have been clearer in my first post... Sorry.
