1. Glenn Barber
  2. PowerBuilder
  3. Tuesday, 13 February 2018 17:45 PM UTC

We have an app where the summary band of a total needs to print on the bottom of the page much like a footer (there is a page break on group change).

We tried conditionally displaying the footer, but even with the footer collapsed and autosized and the objects rendered invisible, the datawindow still preserves extra blank space for the footer.

So what we really wanted was to do  was a page break on the group and show the summary band at the bottom of the page.

Is there some way we can physically position the objects in the group summary band so they are located on the bottom like a footer?

Gimmy Susan Accepted Answer Pending Moderation
  1. Wednesday, 14 February 2018 10:58 AM UTC
  2. PowerBuilder
  3. # 1

you can use a nested report.

GMY

Comment
There are no comments made yet.
Lars Mosegaard Accepted Answer Pending Moderation
  1. Wednesday, 14 February 2018 00:03 AM UTC
  2. PowerBuilder
  3. # 2

Hi Glenn,

To simulate the group trailer location being same as footer, as an experiment, I tried changing position of all objects in the group footer to background, the y to 4200 and visible conditional as in other post. 

This works well, except when the group row count on the last page of the group happens to have rows too far south - if that makes sense.

That renders this idea useless and a bit fiddly.  

Other than a total rework using sub-reports, I am out of ideas.

Good luck :-)

-Lars

Comment
  1. Lars Mosegaard
  2. Wednesday, 14 February 2018 05:51 AM UTC
PS in the old days using line printers we would issue carriage returns until the next line would print near the bottom.  This could be simulated by inserting empty rows at the end of each group control break so that the summary hits the vertical position of the footer.  So if you can fit 42 on first pages and 40 on last page and you have 100 rows you would insert an extra 24 rows as each group must have exactly 40, 82, 124... rows. Just a thought

  1. Helpful
There are no comments made yet.
Govinda Lopez @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 13 February 2018 18:59 PM UTC
  2. PowerBuilder
  3. # 3

Hi Glenn,

 

I believe this has already been posted here: https://community.appeon.com/index.php/qna/q-a/footer-only-on-last-page-of-dw-group

 

Regards,

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.