Dynamic/conditional page break?

[Niniel]

Hello,

I was wondering if there was such a thing as a "dynamic [or conditional] page break". With that I mean the following:

I have 2 memo fields in my table, and of course I cannot predict how much text will be in those.
So what's the best way to put those on the report without wasting too much space?
I could have them adjust in size automatically depending on amount of the text inside, but to do about the things that come afterwards?
I was thinking that maybe there was a way to put a page break in the report that only starts a new page if the memo field takes up more than 50 % of the page.

Or would it be better just to give each memo field a page, or maybe 1/2 page and be done with it?

Any thoughts?
Thanks.

 

[kalebson]

cant you set this in the Sorting and Grouping area and set it to Whole Group?

 

[Niniel]

Maybe I can, I don't know, that's why I asked.
I don't really have any groups at this point, although from your comment I gather that maybe I should look into that.

 

[kalebson]

Im not sure if you can do it that way or not but do all my page breaks there but you can set a page break w/ the Page Break clicky in the toolbar as well.

 

[Niniel]

Yes, I have one manual page break so far, and I could use more in this case.
I'm just trying to figure out if there's a way to do this that won't waste an entire page per memo field.

 

[kalebson]

Well one thing you could try is make subreports for each memo field and set a page break before them and then one after them. That would keep all the memo fields on one page IF they dont fill the page then it would break to the next page for anything that followed.

 

[Niniel]

I could, true, but I think that may not be necessary since I can - and did - already set them to auto-grow.
Actually, my current setup is very similar to your suggestion - I have a manual page break before my two memo fields, and one after.

That should work fine since I don't expect them to take up more than 1 page together. As a matter of fact, most of the time, they should not take up more than 1/2 page.
Which means 1/2 page will be wasted.

But I have since realized that the functionality I am seeking is already there - when there's no page break between memo fields and the controls below them, the controls will simply show up underneath the memo fields, and move down the page as the memo fields grow.

Which creates a different problem - for presentation purposes, I need to keep some text and a subreport together. When they get pushed far enough down the page, however, they will separate, and the subreport will go to the next page.
I then put the text in the subreport's header, but that's not the solution either since the detail section doesn't stay together and part of it ended up on one page, and the rest on the next page.
What I need now is a setting that forces the entire subreport to stay in one piece no matter what.

 

[yammoo]

please refer to some of my other posts. i found via the net a way to put ur memo fields on a report via how much space relative to it. too tired to repost it......just search all the forums for "memo" and specify either lala or mechele.....that is all i can remember atm. or browse the site of www.lebans.com under forms and/or reports. u may find ur answer there. maybe not. good luck!