suppressing page header after last record is printed 2

[deebaglee]

hi
i have report that picks up works order data and prints one works order per page, however after the last works order is printed i get another page after that with just a page header only i want to supress it but do not know how to please help
ta

 

[stormtrooper]

Right click the page header section on the left and go to format section. Beside the suppress check box click on the x+2. In there type in "onlastrecord;"

 

[rhinok]

It sounds like you've checked the 'New Page After' option for the Group. Uncheck the option, click on the Edit Button ('X-2') for the Property and type in 'Not OnLastRecord'. This should resolve the issue.

 

[deebaglee]

thanks very much problem solved

 

[deebaglee]

hi it worked BUT....in the group footer i have text boxes in which operatives must fill in details such as product temp, housekeeping etc this falls on page two of the works order (we have a duplex printer so it prints both pages on one sheet of paper)
i need the page with the group footer to have the page header printed on it
please advise
ta

 

[lbass]

If it's only the very last page where you want the page header suppressed, you can use the following for your page header suppression formula:

PageNumber = TotalPageCount}

-LB

 

[lbass]

Oops, clicked too fast.

PageNumber = TotalPageCount

-LB

 

[deebaglee]

hi
what is happening is after the last works order is printed i get another page with just the page header on this is the page i want to supress

 

[lbass]

Can't tell from your response what isn't working. We need to know the exact layout of the report. Right now, I'm guessing that you have grouped on work order and the last group shows the work order with details and appears on (TotalPagecount - 2), followed on the next page (next to last) by a group footer, where you want the page header, followed by a blank page. But this is all a guess! Please enlighten us so we can help! Also, it will be easier to help if you explain what happened when you tried previous solutions that did not work.

-LB

 

[deebaglee]

ok after i tried supress "onlastrecord" this resulted in report printing the header on all but the last page (it did however not print the annoying last page with just a header)

consists of

pheader
group header
details section
group footer
report footer

does this help?

 

[deebaglee]

sorry guys i have been told to change the format
ok here goes
the works order we print consists of 2 pages, i want the page header printed on page one and not page two
this works if i enter one works order number in the parameter field however if i enter two or more works orders i get a header on all pages expect the final page
sorry to move the goal post!

 

[lbass]

Go to format section->page header->suppress->X+2 and enter:

PageNumber = TotalPageCount or
Remainder(PageNumber,2) = 0

-LB