1. Ludwin Feiten
  2. PowerBuilder
  3. Thursday, 27 February 2020 13:14 PM UTC

Hi all,

I have a report for employees with a group on the employees. This results in different numbers of pages. Some have one, others two or three pages.
When I print on a duplex printer I don't get a paper feed after each employee. So a report start on the backside of another employee.
Is there a way to force a paper feed on group break like you can reset page count?
 
I know this question is around for a long time - but I couldn't find the answer...

TIA
Ludwin

Ludwin Feiten Accepted Answer Pending Moderation
  1. Friday, 28 February 2020 08:46 AM UTC
  2. PowerBuilder
  3. # 1

Hi guys,

Thank you for your help and good advices.

I had to go through tons of reports. So I‘ve decided not to do a wild hack to solve that problem.
In this case there is only a small line between tricky and creepy.

Duplex printer are around there now for more than a decade. And nearly everyone has one now.
I think it is time that Appeon solves the problem.

I will write an enhancement request!

Best regards
Ludwin

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 27 February 2020 19:16 PM UTC
  2. PowerBuilder
  3. # 2

Hi Ludwin;

   FWIW: When the "New Page On Group Break" does not work for me or I need a little more control - I use a Nested or Composite approach where again, you can set the "New Page" property ON in the various Child DWO's as required.  HTH

Regards ... Chris

Comment
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Thursday, 27 February 2020 13:54 PM UTC
  2. PowerBuilder
  3. # 3

Hi Ludwin

If I have understood correctly the problem is that although you have a page break after the employee, when you duplex this you need to adjust for odd and even page counts and so throw 2 pages when the previous employees was only an odd number of pages.

I've not personally done this but here are my thoughts / options:

You could work out based on the number of rows reported for each employee (computed column count(dataitem) for employee) the number of pages that would have been printed.

Using this you can:

1. Insert a page break control on the group footer if the number of pages is odd ASCII Code 12 would do it.

2. Force dummy rows into a nested DW in the group footer that will force it over a page. Perhaps the nested DW could recieve the number of rows for the employee and based on this select dummy blank rows from a sql query to make it enough to force the page.

All a bit dirty I know but may well achieve the result you need. The only other thing your would need to consider is if they are not printing duplex it would have blank pages in the report also the page length may vary on different printers becuase of the margins....

The easier way to do this in PB is to report each employee separately as a separate print job. The printer will feed automaticaly after each job.

Hope that my old grey wisdom of these srots of problems can help you now.

Cheers

David P

Comment
  1. Ludwin Feiten
  2. Thursday, 27 February 2020 14:15 PM UTC
Hi David,

that's exactly what I need.

I hoped Appeon would have done that for me and all the other with duplex printers in the meantime :-)

I will try it

Thank you, Ludwin

  1. Helpful
  1. David Peace (Powersoft)
  2. Thursday, 27 February 2020 14:35 PM UTC
No problem, certainly the easiest solution is to report each employee separately as a separate print job. The printer will feed automaticaly after each job
  1. Helpful
There are no comments made yet.
Philippe PILAT Accepted Answer Pending Moderation
  1. Thursday, 27 February 2020 13:50 PM UTC
  2. PowerBuilder
  3. # 4

Hi Ludwin,

have you tried to check "New page on group break", it's a property on the header group band ?

 

HTH, Best regards

 

Philippe.

Comment
  1. Ludwin Feiten
  2. Thursday, 27 February 2020 13:59 PM UTC
Hi Philippe,

thanks for helping me.

I have checked that property. But it only starts a new page.

What I need is what David described: have an aditional page on odd page count.

Best regards, Ludwin
  1. Helpful
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.