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 - 

Microsoft Dynamics NAV 2016 - How to Configure Phone Client.

Hi All, In this article we will discuss how we can connect Microsoft Dynamics NAV 2016 with New Client Launched i.e. Phone Client. This Article Contain Steps for a Android Phone as I have Only Android Phone. I am doing it having all tiers on my windows 8 machine, steps remain same for multiple servers but issues might be different. What we Need (Other what we discuss in this article) -  The Service Tier should be on Public IP . Some of the Data-card does not Provide you Public IP. check it for sure.

Download Microsoft Dynamics Business Central on Premises 2020 Wave 2 Release.

 Hi Readers, As Expected Microsoft have released #msdyn365bc 2020 wave 2 is available.  This article provides details of the new release. The 2020 release wave 2 for Business Central delivers a wealth of new features. Read What's new in 2020 Release Wave 2 here .  Dynamics NAV Customers upgrading to Business Central on Prem will be able to run business central on premises, move to cloud or choose a hybrid approach.