15
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?
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.).
#1
André Arnaud de Cal...
291,703
Super User 2024 Season 2
#2
Martin Dráb
230,433
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
