Page break causing problems

[DugzDMan]

I have a report broke down into sections (Master - Detail).

Here's an example:

       (Cell)          (Cell)          (Table)
From Date  Thru Date  Account#  Usage Type   Usage
   1/5/03 - 2/4/03    12345678  Usage #1     1,234
                                Usage #3     2,345
...

The problem I'm running in to is when there are many Usage Types. If there are more usage types than can be shown on one page, it moves the Usage Type table to the next page. If the usage types can't all fit on one page, then that is fine. I do however want to avoid a page break if posssible. The problem comes in when it moves the table, it leaves the other cells on the prvious page.

Like this:

From Date  Thru Date  Account#  Usage Type   Usage
1/5/03     2/4/03     12345678  

<Page Break>

From Date  Thru Date  Account#  Usage Type   Usage
                                Usage #1     1,234
                                Usage #3     2,345
...

Is there a way to keep the table with the labels, even if it has to break over multiple pages?

Thanks!

 

[nimmy99]

try that format table- Page Layout , check avoid page break

 

[DugzDMan]

I've already done that. Since it sees that it is going to be broke, it puts it to the next page. This leaves the dates and account number by themselves on the previous page. Is this just another BO bug? I know they had one a while back where you could avoid a page break down, but not left/right.

Thanks!

 

[DugzDMan]

OK, I've finally got it to work. I had "Avoid Page Break in ..." checked for the section and the table. Once I removed it from the table, it works fine. Now, it puts the table (and related cells) on a new page if it can't all fit on one.

 

[naga5566]

If i got ur question right then you can do this way.
select the cell and go to properties(Right click).
Select the Alignment Tab.check the box for Repeat on every page.
I think this will solve your problem.
Thanks
Vijay

 

[DugzDMan]

I've tried that, but it still doesn't repeat the cell on each page. I figured it might be something wrong with my machine as I've been seeing other quirks lately as well.

I can deal with it, I'll just have to see what the users think

Thanks!