Skip to main content
Answer

PageCount and PageIndex in Subreport

  • December 11, 2023
  • 2 replies
  • 180 views

Forum|alt.badge.img

Hello, can we integrate the PageCount and PageIndex/PageOf variables into a Subreport? We aim to develop a Footer-Subreport for inclusion in all our reports. However, we encounter a challenge where the Page-Count consistently shows as 1 of 1, regardless of the actual number of pages in the report.

So Main Report => Subreport 

 

Inside of the Subreport: = Switch( [@Locale] = 'de-de', 'Seite'+' '+[@PageIndex]+' '+'von'+' '+[@PageCount], TRUE, 'Page'+' '+[@PageIndex]+' '+'of'+' '+[@PageCount] )
 

 

Best answer by BenjaminCrisman

@jwestermann17 The subreport will not work with paging, this is not the design intention of a subreport, as there are a number of functions which do not work to incorporate in a subreport and expect to see them on the main report. The reason for this is that the subreport is meant to be thought of as just a page in the main report, not quite a full report embedded within another report, so global fields will only work in the main report (or the subreport if it is ran by itself).

2 replies

Forum|alt.badge.img+1

I have been unsuccessful in this.  What I do as a workaround is to use a footer under the sub report.  Set the footer’s ProcessOrder to Always and use this formula:  ='Page ' + [PageIndex] + ' of ' + [PageCount]

 

 

 

 


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • Answer
  • September 9, 2024

@jwestermann17 The subreport will not work with paging, this is not the design intention of a subreport, as there are a number of functions which do not work to incorporate in a subreport and expect to see them on the main report. The reason for this is that the subreport is meant to be thought of as just a page in the main report, not quite a full report embedded within another report, so global fields will only work in the main report (or the subreport if it is ran by itself).