{{sidenavigation.sidenavigationExpandLabel}}
{{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

i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - TotalPageCount