Call report by passing Parameter

jsshivalikjsshivalik Member Posts: 67
Hi

I have below code and i want if Amt[2] > 0 then report is called by passing Item No



Item - OnAfterGetRecord()


FOR i := 1 TO 10 DO BEGIN
ILE.RESET;
Amt := 0;
Qty := 0;
End;

ILE[2].SETCURRENTKEY("Item No.","Entry Type","Posting Date","Location Code");
ILE[2].SETRANGE("Posting Date",StDt,EndDt);
IF ILE[2].FINDFIRST THEN REPEAT
ILE[2].CALCFIELDS("Cost Amount (Expected)","Cost Amount (Actual)");
Amt[2] += ILE[2]."Cost Amount (Expected)"+ILE[2]."Cost Amount (Actual)";
Qty[2] += ILE[2].Quantity;
UNTIL ILE[2].NEXT=0;



IF (Amt[2] > 0) THEN


Thanks

Answers

  • kenyokenyo Member Posts: 40
    edited 2019-05-21
    correct me if i'm wrong but i think you could store the item no in a get-function (as return value) , call the report (REPORT.RUNMODAL) and fetch the value from inside the report wherever you want by calling the get-function...or the other way around by putting a set-function inside the report and before you call it you set the variable
Sign In or Register to comment.