Skip to main content

Does anyone have any ideas on how to configure Page Footer only appear on last page? I have set the behaviour to Print on Last Page as “TRUE”. However, when the report are more than 3 pages long, the footer shows up on the succeeding pages except for the first page. Below is the screenshot of my report designer configuration for the Page Footer section. 

Thank you in advance for any help. 

Anne Samson

There should be a few different ways you can accomplish only printing on the last page of the report.

The first option would be to create a “Report Footer” section by right-clicking on the yellow background behind the report, and adding the new section from the context menu. The report footer should only print on the last page of the report.

 

If you need to keep the page footer section, you may be able to use the VisibilityExpr along with PageIndex and PageCount global variables to only make that section visible if the PageIndex=PageCount.


There should be a few different ways you can accomplish only printing on the last page of the report.

The first option would be to create a “Report Footer” section by right-clicking on the yellow background behind the report, and adding the new section from the context menu. The report footer should only print on the last page of the report.

 

If you need to keep the page footer section, you may be able to use the VisibilityExpr along with PageIndex and PageCount global variables to only make that section visible if the PageIndex=PageCount.

I’m facing this same situation, trying to print a static signature box on the last page of the Count Sheets for inventory. I tried using Report Footer and it does work, sort of: it does print on the last page but it makes a whole new empty page to print, even if there’s room on the last page showing data.
 

Last Page of Data
Printed last page

 

I switched to PageFooter got the same result as the OP: PrintOnLastPage = True, but box prints on every page except page 1.

I see where I could use VisibleExpr to do your solution but cannot for the life of me find the correct syntax for using PageIndex and PageCount together to indicate the proper LastPage.

Can you spell this out for a simpleton newbie like myself?
TIA!


@akatzkomori It seems like in your example, there is a page break specified in either one of the group footer sections or on the Report Footer. It’s hard to tell without seeing your RPX file, but I’d first check if any of the sections have the “PageBreak” property set to something other than None. I

 

Using the Page Index and Page Count is a bit more complex, but most of the standard Acumatica reports should have something similar. Check out the SO641000.rpx Sales Order report for a good example. The “groupInvoice” footer near the bottom will show the text “Continued..”  for every page but the last if more than 1 page.

This requires changing the ProcessOrder property of fields and sections in order for the report to actually know what page is the last report page, which is why it adds some complexity. You can see how some sections and fields have this property set to “Always”.


@mbridges00 Thanks, it was the former in your suggestion: that last Group Footer before my Report Footer had AFTER as the page break setting. Set that to none and got my sig boxes on the last page.

Appreciate the assist!

 


Reply