Skip to main content

NAV - RTC Report Reset Row No. / Serial No. on Group Change.

Hi all,

This post is based on query of one of my reader Peter Huba.

During Report Development we face queries like resetting the Row  No. when there is a change in Group.

What we exactly Try To Do ?

We tried to write C/AL code based on our group and try to set/reset a variable.
But in some cases that doesn't help too as we have visibility condition in RDLC Rows which create issues.

What we Don't Do ?

We don't try to lookup the power of Visual Studio for same. We still try to beat the bush using C/AL Code.

Now let's see how simple it is using Power of Visual Studio -

1. Created a simple Report Using Item Ledger Entry Table.

2. In Layout Group the Report with Item.

3. In above Screen you can see Sr. No. , Lets see what is the expression that i have used inside that.
Visual Studio have a simple function RowNumber To get The Row Number. Function take Group Name as Parameter as shown Below.

4. Now Let's Save and Run the Report. The Output seems as below.

5. There are some items which don't have Remaining Quantity, as highlighted above.
6. Let's add a visibility condition for Excluding those lines having remaining quantity as ZERO.

7. Let's Run The Report and select Option to Exlude Lines With Remaining Quantity as ZERO.

And the Output of Report is as below.

I hope this will help some of my readers and would like to hear from you as comment to this article.

If required you can download the Report from My SkyDrive Folder.

FileName - NAV2013R2_Report_Serial_No_With_Grouping.rar

Saurav Dhyani


Popular posts from this blog

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 - 

Error After Restore SQL Backup of NAV 2013 Database

Hi all, we are facing a conman issue during restoring a SQL Database backup restored for NAV 2013. While Trying to run object from Object Designer we get below listed error (even the service is configured properly) - --------------------------- Microsoft Dynamics NAV Development Environment --------------------------- There are no NAV Server instances available for this database. You must ensure that a NAV Server instance is running and is configured to use the database before you perform this activity. --------------------------- OK    ---------------------------

Future - What Next After NAV 2016. Code Name - Madeira...

Hi All, While Browsing web I came across some article which says about next release of Microsoft Dynamics NAV. Let's see the History of Code Names Given to Previous Version  - NAV 2013 - Code Name 'Sicily' NAV 2015 - Code Name 'CRETE' NAV 2016 - Code Name 'CORFU' And as we all know that all these are the Islands.