1. Select the Primary Data Source:
From the data menu, choose 'Workorder' to set it as the starting point for your report.
2. Establish the First Join:
In the 'Join data' section, activate the join by clicking on the link icon next to 'Workorder'.
Select 'Sessions' from the adjacent dropdown menu to join it with 'Workorder'.
Create the join condition by clicking on the plus sign (+) and then link **Workorder id** from the 'Workorder' table to **Workorder ID** in the 'Sessions' table.
3. Create the Second Join:
Move to the next 'Join data' section and click on the link icon next to 'Sessions'.
From the new dropdown, choose 'Stock' or the table where the serial numbers are stored.
Set up the join by clicking on the plus sign (+) and connect **Sessions id** from the 'Sessions' table to **Session ID** in the 'Stock' table.
4. Apply the Necessary Filter:
In the 'Filter' area, make sure that 'Production Status is valid' is selected to refine the data for the report.
