How do I get a report showing 1 transaction per item?

(0) Share

Report

Posted on by MMatthewsJr

I got the Registered Warehouse Lines and the Destination No. is what I want. So, how do I combine them under one Registered WP number and the Destination No.?

I have a example:

All responses (4)

Answers (0)

Suggested answer

Nitin Verma 21,081 Super User 2024 Season 1 on at

Like (0)

Report

RE: How do I get a report showing 1 transaction per item?

You need to do the grouping on First column.
MMatthewsJr 10 on at

Like (0)

Report

RE: How do I get a report showing 1 transaction per item?

Here's the AL file and the RDLC file.

[View:/cfs-file/__key/communityserver-discussions-components-files/758/Rep_2D00_Ext50351.WhseShipCreatePick.al:320:240][View:/cfs-file/__key/communityserver-discussions-components-files/758/WhseShipRegPick2.rdl:320:240]
Suggested answer

Inge M. Bruvik 993 Super User 2024 Season 1 on at

Like (0)

Report

RE: How do I get a report showing 1 transaction per item?

Maybe you can share the source code of your report? That makes it easier to assist you.
Suggested answer

Andy Sather on at

Like (0)

Report

RE: How do I get a report showing 1 transaction per item?

Hello,

If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.