Please try the following:

If the report works fine in Crystal Reports but not in the Blackbaud application:
  1. Open the Export
  2. Click Export Now and save the data
  3. Click Save and Close on the Export
  4. Run the report from Reports > Custom Reports again
OR
  1. Open the report in Crystal Reports
  2. Go to Database > Database Expert
  3. Click the Links tab
  4. Click Clear Links (click OK to any messages that appears)
  5. Click Link (click OK to any messages that appear)
  6. Change the Table Joins to Left Outer Join
If the error occurs from within Crystal Reports:
  • Create a subreport
  • Transfer some of the fields from the main report to the subreport