How to convert Amount in Words in Reports of MS Dynamics NAV?

MS Dynamics NAVISION report 

I come to go along a situation where I have to show total in words. I am designing a report where I am going to show the total in MS Dynamics NAV. I am designing a report which shows total of customer's balance in Words. Let's have look.

We have to use a variable of report type 1401 which is using two functions:-

InitTextVariable & FormatNoText

I am using the REPORT Check 1401 and  there may be diffrence in Database localisation. In INDIAN VERSION these two functions exists.Now I am going to show how I have used these reports and functions in my report.

When you see in INDIAN version of DB inside report 1401 there are above functions being used.

For the example I have taken Customer Table with the following Fields.

This is the code Which I have used to retrieve the total of Balance Field.

In the last screen I have selected a particular user For the balance.

You can see the amount in words which you can show in your report.

I hope you understand the process and code of using the functions in your report. For Further querry please comment.

In my above report code I have taken (notext VARIABLE of datatype text) which is a type of array with dimension 2 notext[1] contains your required result for showing amount in words.

Thanks,

What is the diffrence between SSRS & RDLC Reporting & Classic Reports?

About Classic Client and Report in MS Dynamics NAV Version.

The designing of MS Dynamics NAV Reports in 2009 is called as Classic Client Report Designing where there were tools in NAV Dev Environment Only. Classic Client Report Designing is done within MS Dynamics NAV. Tools are provided in Dev Environment itself. About the background working in MS Dynamics I think it should have taken data direct from database like in SSRS Reporting.

About SSRS Reports SQL Server Reporting.

We can choose SSRS (SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft) reporting in NAV 2013 from the Tools Menu. The reporting is done via directly through SQL Server Based on our System. It is very fast reporting format as data is directly created from SQL SP and taken with tables and reporting services. There are few constraints like the tools provided in the SSRS reporting Dev Environment.

About RDLC Reports Report (Report Defination Language Client Side) 

From NAV 2013 we have only choice For RDLC or SSRS reports. The designer is with Visual Studio. We have options to select our report design tool within Tools menu. RDLC report uses and combines Report.RDLC  medata of Plain XML File with Dataset Defination.


I hope my R&D work have issued and clear some doubts. Although if there is any more suggestion I would like you to comment and tell more viewers of Blog to clear there doubts.