Hallo all,

I want to use 3 DataItems in a report.

The first DataItem is Vendor ,the second is Vendor Commodity Group and the last is Comment Line.

The Join between Vendor and Vendor Commodity Group is Code=FIELD(Vendor Commodity Group Code) and between Vendor and Comment Line is No.=FIELD(No.)

the problem is when I want to use the description from Vendor Commodity Group in a tabel in report layout the data dosen’t come.

Any ideea?

Store the description in a variable and then use the variable in the report layout and it should show the information, make sure to clear the variable onaftergetrecord otherwise it will duplicate the same data.