Adding New Joins in the Costpoint Shop Floor Time Reconciliation Report

You may want to further customize your Costpoint Shop Floor Time Reconciliation Report by defining new join relationships. Do this in the Edit mode.

To add join relationships in the Costpoint Shop Floor Time Reconciliation report:

  1. Open the Costpoint Shop Floor Time Reconciliation Report in Edit mode.
  2. Click the Queries () icon on the left-hand side of the screen.
  3. Expand QUERIES and look for Query 1.
  4. Expand Query 1 and clickJoin (yellow boxes).
  5. On the Join Relationships dialog box, click a query object in the CP TS DATA box that you like to create a new join relationship from (for example, Employee ID).
  6. Click the New Link button.
  7. Click a query object in the SFT DATA box to link to (for example, Pay Type).
    Before joining, carefully examine the implications of joining (you do not want to create a loop join).
  8. Click OK.