If your software is hosted through Blackbaud Hosting Services, contact Support and reference this article.

Note: Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup solution.

Note: Print and read all of the following instructions before running the plug-in.

  1. Log in to the workstation as a local administrator
  2. Download the appropriate plug-in for your version of The Raiser's Edge:
  1. Save CleanupPivotReportQueries.zip to the local hard drive of any workstation with The Raiser's Edge installed
  2. Double-click CleanupPivotReportQueries.zip
  3. When prompted, unzip the files into the \Plugins folder on the workstation. (The default path is C:\Program Files\Blackbaud\The Raisers Edge 7\Plugins.)
  4. Register UpdateDBPlugin.dll on the workstation
  5. Have all other users exit and sign out of The Raiser's Edge
  6. Log into The Raiser's Edge
  7. Click Plug-Ins from the navigation bar. The Plug-Ins screen appears.
  8. Click the Clean Up Pivot Report Queries link
  9. Follow the prompts