Important Content Update Message
We are currently updating the OP Help Center content for the release of OP 20. OP 20 (official version 20.0.x) is the certified, 2015 Edition, version of the Office Practicum software. This is displayed in your software (Help tab > About) and in the Help Center tab labeled Version 20.0. We appreciate your patience as we continue to update all of our content.

Workaround: How Do I Update Reports Not Outputting the Signature in OP 19?

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.

  1. Click Tools on the Ribbon.
  2. Click OP Reports in the Applications group. 
  3. Log on to the Reports Designer. Your logon must have appropriate permissions to access the Reports Designer.
  4. Locate the report.
  5. Right-click on the report and select Design from the dropdown menu.
  6. Click on the Data tab.

  1. Click on the Tables button. OP 19 opens the Query Designer window. 

  1. In the bottom data grid, select the GRAPHICS line. In the Join Type column, OP 19 displays the Join Type button.   

  1. Click the Join Type button. OP 19 opens the Join Table window.

  1. In the lower data grid, select the existing Joined Fields item.
  2. Click the Remove button in the center of the window. 

  1. In the GRAPHICS Fields data column, select the ADDR_ID field.
  2. In the column to the right, select the P_ADDR_ID field.
  3. Click the Add button. OP 19 adds to the two fields to the Joined Fields data grid at the bottom of the window.

  1. Click OK. OP 19 returns you to the Query Designer window.
  2. Click OK. OP 19 saves and closes the updated report.