0

Inserting page break if NL Rows won't fit on current page

Jet Reports Historic Posts

April 25, 2014 15:08

None

Follow

Hi All,

I searched the forums, and to me this sounds like something somebody has requested previously, but not yet possible.
I would like to have a page break inserted into my report, if the number of rows returned by the NL function will not fit on the current page.

I played around with page breaks a bit in Excel, but could not get it to function as I had hoped.

Cheers,
Eds

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts April 29, 2014 09:54

  Hi Eds,
  
  i would do it in Excel, page-layout or page-setup ( i don't know the english-translation ;) ).
  
  Is there something you can't do in there? Can you give an example?
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts April 29, 2014 13:36

  Hi Jetsetter,
  
  Unfortunately, I want the page break to occur in the middle of an NL(Rows) function, and I want it to only apply if the whole row and sub rows don't fit on the page.
  
  I have added an image which shows the report in which I want this to happen.
  From the example, you should see three coloured boxes. The three boxes are NL rows functions, all nested.
  The first red box is getting a list of vessels, the blue box is getting a list of warehouses for that vessel, and the green box is getting a list of customers for that warehouse and vessel.
  
  As you can see, the vessel and warehouse names sit on one page, while the list of customers are pushed onto the second page.
  What would be nice, is for Jet to realise that the whole lot doesn't fit on the bottom of page one, so rather than splitting it between two pages, it would move the warehouse and customer name down onto the second page.
  
  I hope that makes sense, and shows what I would like to achieve.
  
  Eds

  • Untitled.png
• 0
  
  Jet Reports Historic Posts April 30, 2014 08:04

  Ok, now I understand.
  But I don't think that this is possible in Jet.
  I would try to do it in VBA with a macro, depending on row-numbers and value in column F and/or J.
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts April 30, 2014 08:21

  Thanks Jetsetter,
  
  Yes I wasn't sure it was possible.
  I do not really know VB at all, so will need to seek some assistance with this.
  
  I might just try and convince the user it is for to ignore the page break element for now, to save me some work :)
  
  Eds