1. Diane Royer
  2. InfoMaker
  3. Friday, 18 June 2021 18:54 PM UTC

I'm working on a report that will double for a contract.  The report is grouped by employee id number.  I have data in the group header and group footer.  The Detail section lists the courses the employee is teaching.  Everything works fine, unless the employee is teaching more than 6 courses.  In those cases, 5 courses are listed with the header and then the rest of the first page is blank.  The sixth course is listed on page two with the footer data.  Is there any way to keep the detail together and have the footer be what wraps if the report goes to two pages?

 

Any advice you can provide would be greatly appreciated.

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 June 2021 19:14 PM UTC
  2. InfoMaker
  3. # 1

Hi Diane;

  Try adding this command to your DW Control's "RetrieveStart" event ...

  • THIS.Modify ( 'datawindow.PushCutControlToNextPage=yes' )   

HTH

Regards ... Chris

Comment
  1. John Fauss
  2. Friday, 18 June 2021 20:52 PM UTC
Fascinating - Where is that property documented, Chris? I did a search in both the DataWindow Reference and the DataWindow Programmers Guide (latest online version) and came up empty.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 18 June 2021 21:29 PM UTC
Hi Olan ... nope. Only developers with a Secret PB Decoder Ring know of this ones existence ... LOL!
  1. Helpful
  1. John Fauss
  2. Friday, 18 June 2021 23:14 PM UTC
YAUF (Yet Another Undocumented Feature). It doesn't matter to me if these pre-date Appeon's ownership of the product or not... if I was a member of the engineering and/or documentation teams, I would be embarrassed each time a YAUF was made public, enough to get it documented.
  1. Helpful
There are no comments made yet.
Diane Royer Accepted Answer Pending Moderation
  1. Friday, 18 June 2021 19:24 PM UTC
  2. InfoMaker
  3. # 2

Hi Chris,

Thank you so much for the suggestion.  Could you tell me how to get to my DW Control's "RetrieveStart" event?  This isn't something I've done before and I'm not sure where to look for it.

Comment
  1. Chris Pollach @Appeon
  2. Friday, 18 June 2021 20:18 PM UTC
If I recall correctly ... is not "Jenzabar" a commercial package built by a PowerBuilder based software company?
  1. Helpful
  1. Diane Royer
  2. Friday, 18 June 2021 20:22 PM UTC
Yes, that is correct.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 18 June 2021 20:27 PM UTC
Then you would need them to embed this command in the "Jenzabar" application logic for you.
  1. Helpful
There are no comments made yet.
Diane Royer Accepted Answer Pending Moderation
  1. Tuesday, 22 June 2021 20:34 PM UTC
  2. InfoMaker
  3. # 3

I just found out that Jenzabar will not embed this code for me.  Is there another way to get it added?

 

Also, Jenzabar mentioned that I could use "Newspaper Columns".  However I can't figure out how to get just the Detail section to use the columns.  When I mark this setting and the go and mark all fields not in Detail as "Hide Snaked", it still puts the whole report in two columns.  Is there any way to get just one section to do the Newspaper column?

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.