1. Winthor Caingles
  2. PowerBuilder
  3. Monday, 21 June 2021 03:13 AM UTC

Good day,

 

Please help...

 

How can I suppress the headers on the second page? so that the list of rows will occupy the header portion.

 

thanks in advance

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Saturday, 26 June 2021 19:14 PM UTC
  2. PowerBuilder
  3. # 1

I'm not sure if my solution might solve your problem, but here it is attached. (I've used PB 2017 r3)

No need for anything else than to create a group by a computed column which holds "page()" and sort by that same computed column, possibly followed by any other sort fields you might want.

Don't use the "header" but instead use the "group header".

Set "suppress group header":

Attachments (1)
Comment
There are no comments made yet.
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Friday, 25 June 2021 06:45 AM UTC
  2. PowerBuilder
  3. # 2

Can you try this

1.  For all columns, expression should be if (page() = 1, 'value', '')
2.  Visible property should be true for all columns.
3.  Size all required columns with minimum height 
4.  Set Autosize and slideup properties for all required columns  (as in the image)
5.  Set Autosize property for the band.

Hope this will work.

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 23 June 2021 10:40 AM UTC
  2. PowerBuilder
  3. # 3

Maybe it can be done by setting "slide up to All Above" and setting the height and visibility of all objects in the header to 0, based upon the expression suggested by Chris: if ( page() = 1, ..., .....)

Also, make sure that when you save the dw control, the header is set to 'autosize height' and the height = 0 (that's what Olan means when saying to make sure the header is all slided up, I think).

Another thing I can think of, is to define a main group based on "page()". Set the header not to show if it's not the first page of the group or something like that also thinking of the attribute of page-break on group (something like that).
At least I think there was some way of choosing not to show the header on other groups as the first one.

If I have some time, I'll try it out myself, but won't be today probably.

regards

 

Comment
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Wednesday, 23 June 2021 05:03 AM UTC
  2. PowerBuilder
  3. # 4

Hi Winthor,

I also had such problems and I only know a way that is only usable in reports if it doesn't matter to have alway print preview on.

My solution: Use a composite datawindow as report. Create a child datawindow for the header and place it as first datawindow in the detail band of your report (you may also put the header information directly in the report). Also add a second child datawindow with the data but without a header.

HTH,

René

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Tuesday, 22 June 2021 17:29 PM UTC
  2. PowerBuilder
  3. # 5

What Chris said.

Also, be sure to have the HEADER BAND property set to SLIDE ALL UP.
And for good overkill, add an expression where the HEIGHT of the BAND:   IF ( page() = 1, <actual height>, 0 )

Comment
  1. René Ullrich
  2. Wednesday, 23 June 2021 04:55 AM UTC
I think it's not possible to use an expression for the height of a band. :-(
  1. Helpful
  1. Olan Knight
  2. Thursday, 24 June 2021 15:24 PM UTC
Sadly true, this needs to happen in code:

<DW Control Name>.Object.DataWindow.Header.Height = X
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 21 June 2021 18:36 PM UTC
  2. PowerBuilder
  3. # 6

Hi Winthor;

  Have you tried placing an Expression on the Heading objects using an IF ( ) command on the Visible property to test if the Page Number is 1? If not, set the object Visible to FALSE.

Example:    IF ( page( ) = 1, 1,0 )

Regards ... Chris

Comment
  1. René Ullrich
  2. Wednesday, 23 June 2021 04:58 AM UTC
This makes objects invisible but the header still consumes place. Also Autosize.Height seems not to help.
  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.