1. CJ Lai
  2. PowerBuilder
  3. Thursday, 2 April 2020 19:36 PM UTC

Hi

I am 'recycling' Mike Monette's question I found online (from 1997, long live the internet!!) about placing a page break onto a datawindow.

You may find his original post here - https://bit.ly/2UAZpbu

I'll copy and paste it here as well just so you don't need to hop out of here - 

 

I have a long (3 page) freeform datawindow with an external data
source.  All of the lines are unique (there are no groups).  PB sees
this as a single page report, and when I print the datawindow, PB has no
regard for where the last line on the page is; it cuts of the last line
and reprints it at the top of the next page.

I'm looking for a way to insert page breaks to control where paging
occurs when printing.
This sounds to me like it should be a simple requirement, but I'm
stumped.  Does anyone have any ideas?

Thanks in advance,
Mike Monette
BDM International  (08/12/1997)


I have the exact problem. The only difference is I populate my dw with a simple SELECT.

Please keep in mind,

- it's a free form presentation (ONE row spans over many pages)
- there is no Grouping. One row has about 150 columns (it's a medical record)

How do I get PB to realize some column is about to be cut in half at the end of a page and place a page
break so that the said column would be printed in whole on a new page?


Right now, I just manually move those columns downward so they can be printed on a new page.

Although it look nice on the printout, it looks silly at runtime as this dw looks like it's not evenly spaced out.


At any rate, if any of you could provide a solution to this, it'd greatly appreciated.

Thank you

CJ
Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 2 April 2020 19:48 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi CJ;

  Here is a trick that I use sometimes that might work in Appeon PB (it does for me in PB2017, PB2019, 2019R2, etc) where a "Blank page or improper split occurs in PB DataWindow Report" ... use the following:

In the RetrieveStart event of your DW Control, try adding ...

 THIS.Modify ( "datawindow.PushCutControlToNextPage=yes" )

HTH

Regards ... Chris

Comment
  1. Chris Pollach @Appeon
  2. Monday, 6 April 2020 19:41 PM UTC
Hi CJ ... that is "Awesome news - thanks for the feedback! :-)

Hi John .. this is "un"documented. ;-)
  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 26 March 2024 14:28 PM UTC
Hi Arnd;

Yes thanks Arnd, the Appeon documentation team just added that (finally) to the current PB documentation! :-)

Regards .. Chris
  1. Helpful
There are no comments made yet.
Troy Cowan Accepted Answer Pending Moderation
  1. Monday, 25 March 2024 18:28 PM UTC
  2. PowerBuilder
  3. # 1

 

Is this an example of the issue spoken of in this thread? If so, can you expound on the PushCutControlToNextPage fix? I've tried it and it has no effect on my print. 

 

Version 2023 build 1506

Windows 10 Enterprise

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.