Form to report conversion

bharathnan
bharathnan Member Posts: 92
when i transform a form of particular customer the No. field of customer should be updated in filter page of report....
Can anyone help me ,....
I have attached the screenshots of those

8klas3r20puc.png

84g41xq5nqjm.png

please help me

Answers

  • Karenh
    Karenh Member Posts: 209
    When calling a report from a form, first create a variable for the table and set a filter on the customer no.
    Is it the customer table that is the primary table for the report? If so, it would look something like:
    Cust.RESET;
    Cust.SETRANGE("No.",custno);
    Cust.FINDFIRST;
    Report.RUNMODAL(reportno,TRUE,FALSE,Cust);

  • bharathnan
    bharathnan Member Posts: 92
    Hi karenh,
    I tried you code but i get the error message as follows,

    tu33b6k87e00.png
    buav3pigzhgr.png
    gy89d2j5lhmj.png

    after trying that code i get the following error can anyone suggest me a suitable way for that........
    Thanks
  • lubost
    lubost Member Posts: 633
    When you want to call report modally, you have to commit previous transaction. Your code TotableLine.MODIFY starts transaction.