Important – This report must be done in Salesforce Classic as the joined report function is not available yet.
Create a report for ‘UPS Shipments with Order’
Select Report type ‘Joined’. This will allow you to add other relationships to the report.
Click add report type
Add a new ‘Orders with Products’ Report type.
This is what you should see
Remove order number from each of the reports
Add order number into here:
Add the following filter:
Order: Status equals “Activated, Replacement Shipped, Replacement received, Delivered”
Save the report