How to run report from the page in Microsoft Dynamics Navision.

For run the report from the page you have to use REPORT.RUNMODAL Function.


Syntax:Report.RUNMODAL(ReportId,request RequestPageDiaply, PrinterSet set, Record)


Report ID: Here you have to specify the ID of report which you want to run.
Request Page Display: (Default Value Is TRUE), it will ask like Are you want to display report request page or not if you want to display the “TRUE” otherwise “FALSE”.
Printer Set: (Default value is False) make true to use the printer defined as the system printer.
Record: It contains table record which we have to pass to report.

Comments

Post a Comment

Popular posts from this blog

How to make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more

How to create simple report in Microsoft Dynamics Navision.

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...
Read more