{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}}
{{helpModel.downloadHelpPdfDataStatus}}
TotalPageCount
This function can be used in formula fields to get the number of pages in the report.
Note: It is not supported to use this function in some property formulas, e.g. it is not supported to use it in the suppress formula for a section.
If you like to suppress the page footer on the last page, you could set a suppress formula for the page footer section like this "not onlastrecord". The problem is that this will not work in all cases, e.g. if there is a page break in the detail section or you have more than one detail section and there is a page break between the detail sections of one record.
The solution for all cases is more complicated. Therefore follow these steps:
-
create a formula "dummy" with the content "1"
-
add a group and group by the formula "dummy"
-
suppress the group header of this group
-
add a formula "init" with the content "whileprintingrecords;global booleanvar ISLAST:=false;"
-
place this formula in the report header an suppress the element
-
add a formula "checkLastRecord" with the content "whileprintingrecords;global booleanvar ISLAST;ISLAST:=true"
-
place this formula in the group footer and suppress the element
-
enable "suppress blank section" for the group footer
-
add the following as suppress formula for the page footer: "global booleanvar ISLAST;ISLAST"
Usage:
TotalPageCount
Returns:
Number value