Two approvals causing details section of SO report to duplicate

​@MarciaW In situations where there is a duplicate which can’t be avoided, the best way to fix this is to use a subreport to pull in the duplicating data. I think that in this case though you can probably use the StepID from the approval in your join and it should prevent the duplicates. So if you leave the join on NoteID = RefNoteID and add the unique identifier for StepID (which you can find if you add this to a GI and check the results) then you should only get the approver for this step.

Do you need the workgroup approval line? Perhaps adding an additional condition to the join like Assignee ID = Approved by (ID) can narrow down the scope of the join to just the record you want.

For this table there does not seem to be a good way to get the first or last record in the table, but you can use a creative join to do so.

Gabriel Michaud from Velixo posted a similar join on this community some years back. This join comes in handy in a pinch for these types of situations where you need the first or most recent record.

EPApproval Filter is an Alias for EPApproval, so you are joining the same table onto itself. The below will give you the most recent “approved” approval related to the sales order.

​@bwhite49 This type of join where you join a table to itself and then choose a Less Than condition is an easy to get recent records for just about anything 😁

Hi Plambert

In this case it was approved by two people, otherwise that would be the perfect solution!