This article discusses a workaround for updating reports that are not outputting the signature in OP 19. This process uses the OP Reports Designer (which requires permission to access), takes you through finding the bad string-based join, deleting it, and replacing it with a good ID-based join.
- Click Tools on the Ribbon.
- Click OP Reports in the Applications group.
- Log on to the Reports Designer. Your logon must have appropriate permissions to access the Reports Designer.
- Locate the report.
- Right-click on the report and select Design from the dropdown menu.
- Click on the Data tab.
- Click on the Tables button
. OP 19 opens the Query Designer window.
- In the bottom data grid, select the GRAPHICS line. In the Join Type column, OP 19 displays the Join Type button
.
- Click the Join Type button. OP 19 opens the Join Table window.
- In the lower data grid, select the existing Joined Fields item.
- Click the Remove button in the center of the window.
- In the GRAPHICS Fields data column, select the ADDR_ID field.
- In the column to the right, select the P_ADDR_ID field.
- Click the Add button. OP 19 adds to the two fields to the Joined Fields data grid at the bottom of the window.
- Click OK. OP 19 returns you to the Query Designer window.
- Click OK. OP 19 saves and closes the updated report.