Hello everyone, I have created an excel report using location table, item ledger entry table and item table. These all are nested data items. In the item dataitem I have provided dataitemlink as DataItemLink = /No./ = field(/Item No./), /Location Filter/ = field(/Location Code/);
I have used inventory and qty on purch order from item table. The problem is that there are multiple entries for same item no. in ledger entry table therefore item table column are repeating itself due to dataitem link. I want the row to be displayed only once for a particular item no.