How to display vendor detail from vendor code in report

neellotus

Hi All,

I am creating new report from two tables Enquiry & Enquiry Line. And Enquiry Line table contain vendor numbers in "Vendor No." field.

Now i want to print vendor detail on the header of report so i write following code on Enquiry Line - OnAfterGetRecord():-

Enquiry Line - OnAfterGetRecord()

Vendrs.RESET;
Vendrs.SETRANGE(Vendrs."No.","Vendor No.");
IF Vendrs.FIND('-') THEN
vend:=Vendrs."No.";
name:=Vendrs.Name;
add:=Vendrs.Address;

Vendrs is a Record type variable of vendor table.

But it is not displaying vendor details in report, pls tell me where i am doing wrong i will be very thankfull to you.



Neel

mohana_cse06

Are you placing the variables in Enquiry dataitem header or Enquiry Line dataitem header?

You use GET function to retrieve vendor

lavanyaballurgi

try to use your code this way

Vendrs.RESET;
Vendrs.SETRANGE("No.","Vendor No.");
IF Vendrs.FINDFIRST THEN BEGIN
vend:=Vendrs."No.";
name:=Vendrs.Name;
add:=Vendrs.Address;
END;

lavanyaballurgi

And yes GET is much better than SETRANGE