Page 1 of 1

Need sub report to be specific height - keeps growing

Posted: Thu Apr 03, 2014 5:19 pm
by KellyC
We're working on a Purchase Order form and each page has to contain a set amount of information at the top and the bottom.
In the middle of the page we print different item information.

The problem becomes when we have more item information than will fit on a single page. We need to still print the set information on the bottom of the first page, then continue printing the items on the second page.

We have this laid out as a single data band that is the height of the page, can grow is turned off. At the top of the databand we have the purchase order information, vendor information, then in the middle of the page we have a sub report linking to the items, then beneth the subreport we have more information about the purchase order.

What's happening is if there are more items than will fit in the space of the subreport, it grows, pushing the text that should be printing at the bottom of the first page to the second page.

We need the subreport height to be respected. We've tried putting the subreport inside a panel but this doesn't work either.

I'm attaching a generic purchase order form to give you an idea of what they look like, along with a sample I created representing the issue.

Page 1 is a subreport without the panel, page 2 has a panel. Neither work.

Re: Need sub report to be specific height - keeps growing

Posted: Fri Apr 04, 2014 11:23 am
by HighAley
Hello.

We forcibly turn on the Can Grow property of the Data Band if there is a Cross-Tab or Sub-report on it.
So the one way out is to remove DataBand and out the Sub-Report exactly on the Page.
The other way is to Use Page Footers and Headers without sub-reports.

Thank you.