Small and medium business | Business Central, N...

Duplicates rows on report extension using tables join

(5) Share

Report

Posted on by NP-02071313-0

I'm making a reportextension for Business Central.

I added a relation between "Item Unit Of Measure" and "Sales Line" this way :

DataItemLink = "Item No." = field("No."), "Code" = field("Unit of Measure Code");

But when I generate the data in excel for a preview, instead of having a single row with the data I'm adding, it creates a duplicate with the correct data and set NULL for my new fields in the already existing row duplicated.

Here is an example :

RowID | Existing Values | New Values
A     | existing values | NULL, NULL, NULL (wrong values)
A     | existing values | A, B, C (good values)

Expected result :

RowID | Existing Values | New Values
A     | existing values | A, B, C

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Kamal Khakhkhar 3,357 on at

Like (1)

Report
Copy link

Link copied!

Hi there as per requirement ,

when you creating report extension and wants to update layout also for this so for this export the layout then update as per your requirement ,then replace layout in that update the row visibility as per your requirement.

if you find your answer mark it answered.

Thank You.

Kamal Khakhkhar

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,431 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps:

https://demiliani.com/2021/03/12/dynamics-365-business-central-introducing-the-reportextension-object/

https://www.youtube.com/watch?v=eYg7MMPBWxI

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,115 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, have you opened the table and looked directly to see if the data contains error values?

table 5404 "Item Unit of Measure"

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No