Options

Total Pages 2013 R2 - Report

nav_studentnav_student Member Posts: 175
edited 2014-03-07 in NAV Three Tier
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?

Comments

  • Options
    ara3nara3n Member Posts: 9,256
    Do you need to reset the totalpageno = Y?
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    nav_studentnav_student Member Posts: 175
    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>
    
Sign In or Register to comment.