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
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
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":
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.
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
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é
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 )
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