Nirav's Code

We use FORMAT function for convert any date format Ex. FORMAT("Bank Account Ledger Entry”. “Posting Date",0,' <Day,2>.<Month,2>.<Year4>') OUTPUT: 18.08.2016

First we create the report which is display the drop down list of the vendor, so user can select vendor and     generate report and apply this vendor number filter on report data. create new report. Go to “C/AL Globle” and define the variable name ‘Vendor’     Vendor Text 50 Go to “Request page” and add this vendor to page.   -Now got to properties of this vendor And set the ScourceExpr and TableRelation properties value if not set. As show in below image   SourceExpr : Vendor TableRelation : Vendor.No. Now save the report and run it, it will display like.

Try to set ServicePrincipalNameRequired  =TRUE in ClientUserSettings file for this user GO  TO path : "C:\Users\xxxxx\AppData\Roaming\Microsoft\Microsoft Dynamics NAV\60" And find the " ClientUserSettings.config " file. open it and change ServicePrincipalNameRequired = TRUE Note: here Path value may be very base on Navision version install on your machine

For   getting the specific value from the table based on some condition, we use setrange and find function, for example we have to find   department name whose   “Dimention code” is “AREA” and it code value is ‘5000’ . a.        Fist declare Dimention Value table as record. DimValue Record Dimention Value b.       Now write below code DimValue.INIT; DimValue.SETRANGE(“Dimention Code”,’Area’); DimValue.SETRANGE(Code,’500’); Message(DimValue.Name); This above code display name of the department whose code is 500

This problem is generating when you use format address code unit function. So if you use. FormatAddr.Company(CompanyAddr,CompInfo); then check the dimension and variable length size of "CompanyAddr" array . If you not specify then give proper length and its dimension properties.

Go to list and right click on its row and go to Row Group >> Row properties as show in image it will open new window.   Go to general table and add any unique value group on it as show above image

For converting the valid numeric value to words, follow below process. -Create new codeUnit and define two variable as shown below. Name Datatype Subtype Length Dimensions AmountInText Text 90 2 Rpt Report Check Now write wire below code to “OnRun” trigger of code unit. Syntax: object.FormatNoText(<AmountArrayVariable>,<Numeric value>,<Currency Code>) Code:: Rpt.InitTextVariable; Rpt.FormatNoText(AmountInText,2023,''); MESSAGE(AmountInText[1]); Output:

In Navision report we you use table control with grouping then it will create problem some time, its display some extra row with blank values. so for solving this we have to use row visibility properties , Right click on Detail row and go to visibility menu and put expression like =IsNothing(Fields!SalesInvoiceLine_Description_value.Value) Above solution here I have use "SalesInvoiceLine_Description_value" column but you have to use you own value it will solve your problem....

In SQL report builder there is no an type of facility for select the any report control from properties drop down list because in SQL Report builder the is no any type of drop down list , but where in Visual studio report builder there is drop down list so you can essay select the control. So if you want to select any control then you have to select any (top level) control and then press “TAB” key and move to next control and, when you reach to you target control then press properties as show in image.

For adding the new instance in NAV server follow below steps. a. Open the Microsoft Dynamics NAV administration server b. Click on Add instance c. It will open new window as show in figure. d. Now fill the all the detail as show in below image. i. Username: your computer login username  ii. Domain Name: if you have domain server name then write this otherwise you have to write your Computer Name. iii. Password, Confirm Password:  Your computer login Password. e. Now close the window by click on Ok button. It will add new instance to NAV server its show like below. Now open this instance detail and go to edit mode and change server instance name, database name, server name etc. and then save it . f. Now right click on instance name and start the service. As show in below image.

Report is one type of data representation in NAV , report is use to display data from the database to outside user. Here we make simple customer list report as example, for creating simple report using Microsoft SQL server report builder you have to follow below steps. Open the Microdot Dynamics Navision development Environment and  go to “Tools  >> Options ” and go to “Use Report Builder” variable and set it to “Yes” and  then close screen by clicking on OK. Now go to “Report” table and click on “new” button. It will open new windows, here you have to specify the data item as any table which you want to display in report, and here we take “Customer” table as show in below image Now we have to add column which is used in report so for adding this we have to add data columns  for this, so go to next row and select column as data type and for adding column you can go to Option >> Field  menu option as show in below image. Now select the field which you want to use in report.