Grouping In Export To Excel Report Without Layout in MS Dynamics NAV 2017

Grouping In Report with Code in A/L

Hi All,

Today I Got a Requirement for Excel Buffer Report in Navision and with Grouping of Location 

Code in Item Ledger Entry.

Typically it was tough requirement , but thanks to MS Dynamics Community and Saurabh Dhyani Sir

for his valuable time which shared a most important thing and rarest blog of Navision.

Direct Link For Grouping of Reports via Coding in MS Dynamics NAV

I had used the same method  in MS Dynamics NAV 2017. I am Sharing my FOB with you all to 

download and understand the issue better.

Download by clicking the Here..

Useful Points about this Report

1. We can use grouping via C/AL Code.

2. We can arrange the Function via boolean Field.

3. Use of Exit Function in MS Dynamics NAV.

How to do dynamic implementation of decimal place in RDLC Reports?

Dear All,

Today  I had requirement from report in RDLC to implement dynamics Decimal Places. Initially it was to realise but I followed report 206 and once again I got my solution done soon.

For those who still not understand check the red screen there we have dynamic decimal place Value.

Solution :-

To implement this we have to use custom decimal formatting in RDLC reports and in that we had to define Format Value.

For Reference see the screen Shot.

This post also explain to juniors when you need to use Format Value in RDLC Reporting.

Thanks for your time to read my blog post.

How NAV Calculate Unit cost of items in NAV?

How to Calculate Unit cost in Reports of NAV?

Using the below code MS Dynamics NAV Calculates Unit Cost in Report of 746.

ItemRec.RESET;

ItemRec.SETRANGE(ItemRec."No.","No.");

ItemRec.SETFILTER(ItemRec."Date Filter",'%1..%2',0D,CALCDATE('-1D',SDate));

IF ItemRec.FINDFIRST THEN;

ItemCostMgt.CalculateAverageCost(ItemRec,AverageCost,AverageCostACY);

AverageCost := ROUND(AverageCost,GLSetup."Unit-Amount Rounding Precision");