Total Pages 2013 R2 - Report

nav_student

Hi guys,

on the Footer of my report (on NAV 2013 R2) i want to try to put this
Page X of Y

The X -OK

The Y i cannot get

I follow this article http://blogs.msdn.com/b/robertbruckner/archive/2010/04/25/report-design-reset-page-number-on-group.aspx

the Properties on the list for Page Break
Break Location End
Disabled False
Reset Page Number

use this expression:
="Page:" & Globals!PageNumber & " of " & Globals!TotalPages

accroding to the article i have to put:
Reset page numbers with each new page break (e.g. on a group) using the ResetPageNumber property, and reference related page counts (PageNumber, TotalPages) using
=Globals!PageNumber, and =Globals!TotalPages.

Can you help me?

ara3n

Do you need to reset the totalpageno = Y?

nav_student

Hi ara3n,

yes but i have found the solution.

It's very strange solution :shock:

I have to open the XML Editor for the report and added this line

<ResetPageNumber>true</ResetPageNumber>

inside the list

<TablixMembers>
                <TablixMember>
                  <Group Name="list1_Details_Group">
                    <GroupExpressions>
                      <GroupExpression>=Fields!No_SalesInvHdr.Value</GroupExpression>
                      <GroupExpression>=Fields!OutputNo.Value</GroupExpression>
                      <GroupExpression>=Fields!Number_ExtraInvoiceCopy.Value</GroupExpression>
                    </GroupExpressions>
                    <PageBreak>
                      <BreakLocation>Between</BreakLocation>
                      <ResetPageNumber>true</ResetPageNumber>
                    </PageBreak>
                  </Group>
                  <SortExpressions>
                    <SortExpression>
                      <Value>=Fields!OutputNo.Value</Value>
                    </SortExpression>
                    <SortExpression>
                      <Value>=Fields!No_SalesInvHdr.Value</Value>
                    </SortExpression>
                  </SortExpressions>
                  <DataElementOutput>Output</DataElementOutput>