How to put drop down list in report request page in Microsoft DynamicsNavision.

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.