Report returns duplicated rows

(0) Share

Report

Posted on by vali98

I have a report generating a table with material and tool transfers for a chosen order. The rows get duplicated somewhere during the process. I've deleted the code in the report and the rows are still duplicated. The image shows that I have only two rows in the database for "Nr. Articol" (Item) = 1018265, but it is added four times in the report (Cod = 1018265). Where should I look out for the problem? 1321.Capture.PNG

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

vali98 15 on at

Like (0)

Report

RE: Report returns duplicated rows

I've solved it!

In the report, I had to set these properties in dataset designer:

<Transfer Shipment Line>.DataItemLink = Transfer Order No.=FIELD(Document No.),Line No.=FIELD(Line No.)

<Transfer Shipment Line>.DataItemTableView = <undefined>

<Transfer Line>.DataItemLink = Document No.=FIELD(No.)

<Transfer Line>.DataItemTableView = WHERE(In-Transit Code=CONST(TRANZIT))

<Transfer Header>.DataItemTableView = WHERE(In-Transit Code=CONST(TRANZIT))

The missing piece of the solution was Line No.=FIELD(Line No.).

Was this reply helpful? Yes No