Skip to main content
Solved

PageCount and PageIndex in Subreport

  • 11 December 2023
  • 2 replies
  • 84 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).

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img

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

@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).


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings