Form to report conversion

bharathnanbharathnan 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

  • KarenhKarenh 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);

  • bharathnanbharathnan 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
  • lubostlubost Member Posts: 611
    When you want to call report modally, you have to commit previous transaction. Your code TotableLine.MODIFY starts transaction.
Sign In or Register to comment.