report that uses several tables as a source of data

Modibo · 2019-08-15

hello I'm on a report that uses several tables as a source of data
I have a table like dataItems
I wanted to know how to use other tables without adding them as dataItems

suraj92291 · 2019-08-15

adding as a Record variable ? I guess

Modibo · 2019-08-15

Yes,
exactly

TallyHo · 2019-08-15

Take a look here, this is basic stuff.
https://www.olofsimren.com/wp-content/uploads/2014/03/NAV-CAL-Programming-Guide-for-Microsoft-Dynamics-NAV.pdf

sjen · 2019-08-15

Go to global variables and declare your record and the variable and use it onaftergetrecord trigger.

For example, if you have a purchase line data item and you want the job record there, go to onaftergetrecord trigger.

CLEAR(Variable);
IF "Job No." <> ' ' THEN BEGIN
  Job.GET("Job No.");
  Variable := Job.fieldname;
END;

report that uses several tables as a source of data

Answers

Categories