Skip to main content

Microsoft Dynamics NAV 2013 R2 & Later - Report Page Number Format x/y

Hi All,

We have already discussed this in NAV 2009 Reports about how to Set the Page Number in Format X/Y.

But with Microsoft Dynamics NAV 2013 R2 and Later its very simple to configure it. Till 2013 we used to have setGroupPageNo and other functions to reset the Page No.


With Microsoft Dynamics NAV 2013 R2, In Visual Studio or Report Builder, a New options is added in the group that is - ResetPageNumber.



So how we can reset the Page no is using expression in Page Header Like -
=Globals!PageNumber & " / " & Globals!TotalPages
& The Property ResetPageNumber set to TRUE in the Main Group which is List group.

Once that is done the Report should output the Page No as required.

For Detail Explanation watch the video below -

   

Let me know your views as a comment to the article or to the video.

I am planning to do a video series on Report Development in NAV 2016 from scratch. Put your comments if you would be interested in the video tutorial for same.

Stay tuned for more.

Regards,
Saurav Dhyani
www.sauravdhyani.com

Comments

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.