Hi all,
We use Jet report to create a template for our QC department.
The report is created with a rows function within a row function, so not every block has an equal length, see in the example below #19 is 1 production in 2 different variance, row 10000 and 20000 but #17 and #18 have only 1 variance, row 10000.
Is it possible to prevent Excel from creating a page break in the middle of a block when printing?
The grey blocks cover our customer details.
Yes, you can. I'm assuming you are using some sort of Row=# to get each of those larger blocks to repeat and another for the line numbers.
You will need to put an Excel Page Break within the larger group so that it gets replicated along with the OrderNumber group. You will also need to turn on the App Setting->Excel->Preserve Page Breaks.
Hi Bryan, Thank you for your answer.
But now there is always a pagebreak after a block, there fit 7 or 8 blocks an 1 page I just don't want a pagebreak within a block.
Gotcha. I don't think there is a way for Jet and Excel to communicate with each other in a way where Jet will know when Excel is going to page break.
Only thing you could do is to create another group that will put the known maximum number of blocks that can fit on a page but, in my experience, there is always an exception that breaks this type of model.