Tuesday, May 9, 2017

Error The Object File cannot be used with this version of the program in NAV 2013.

Hi all,

While exporting the objects in FOB format we sometime get the below error that says -

"The Object File cannot be used with this version of the program."




I got this error while trying export objects from NAV 2013 installed and trying to export the objects in FOB Format .

 it was due to some exported objects of NAV 2013 lying at the same path.

Once i removed those higher version FOB files from the location i was able to take backup on that location.

Thanks Saurav Sir for your post.

Code.BlankZero use in MS Dynamics Navision 2017 RDLC Reports

Code.BlankZero

Hi ,

Today I went to one of my report built in NAV 2016 for my client wher I faced this issue. And I got a 

new thing in base report. I am sharing it to my juniors in NAV for easy understanding.

Why should we use Code.BlankZero?

Sometimes we need to generate value in textboxes and if its of datatype integer or decimal then it will

be display Zero as output. Few client regret to see that.

Where can you find this used in Base Reports of NAV?

Report 206.

Impact of using Code.Zero

It will only display the value if the record is > 0.

For Reference see the screenshot.

MS Dynamics NAV 2017

MS Dynamics NAV 2017


Sunday, May 7, 2017

How to use Getdata and Setdata in RDLC Reports of NAV 2017?

Hi All,

Today I am going to post how to use GET DATA and SET DATA function in MS Dynamics NAV 2017 RDLC Reporting.

Why we need GETDATA and SETDATA?

We need this functionality in RDLC Reporting so that we will be able to modify the header part with Body part in MS Dynamics NAV.

How RDLC Reports Works?

In RDLC we have 3 Sections on which we have to work with our defied datasets.

Header :- Runs only ones at the start of the reporting.

Body :- Stores all the data and run multiple times untill dataset has records to show.

Footer :- Runs only ones at the last page on reporting.

Examples of Getdata Setdat Reports in MS Dynamics Nav :-

Report 206 and many more.


Steps to follow how to use Getdata and Setdata :-

1. To implement Getdata Setdata in any report you need to copy all code from Report 206 present in RDLC report properties. For Reference have a look.


2. Now you need to find out a textbox which has properties of invisible and copy all code present on its visiblity condition and copy paste it in excel as its my preference to understand better ahead.

3. Now in Excel File we have number of rows and this row number is used in textboxes of Header you can have a look in expression of textboxes present in Header of Report section.

4. To add a Field in existing report you need to add a expression in the last line of this excel and it will be same as the expressions already present and get the number where it is coming. Then you need to insert the textbox and write in expression of Textbox.
Code.GETDATA(No. on Excel Line , 1)



I think it will be enough to explain in theory i will post a video for this topic if my readers want the video to explain.  I hope it will be better for all my NAV developers to design reports in more specific way.


Please comment and subscribe for more posts like this.