Saturday, 14 April 2012
Hi All
I’m creating a report and I want all the report parameters to be input at the request from, not in the Data Items ReqFilterFields.
The report’s base Table is Purchase Line, and to be filtered on Buy-from vendor name.
Now I want a text box in the request from that was a drop down, and show list of my vendors.
What to do ??
VENList := Form Vendor list.
VEN := Vendor Table
txt := Text field
VENList.LOOKUPMODE := TRUE;
VENList.SETRECORD(VEN);
IF VENList.RUNMODAL = ACTION::LookupOK THEN BEGIN
VENList.GETRECORD(VEN);
txt := VEN.“No.”;
end;
Hi mrinal,
my requirement is that in the Request form of Posted gate entry list report, i need filteration for Vendor No. I tried to make key in the table, finally the vendor list is not showing , how to sort out … where did u write this above code ?