The Year column in the Report Periods tab of the Comparisons and Summaries Report changes when saving or running a saved copy of the report

When using the field "Months in the year" when running the Comparisons and Summaries Report, some users may notice that the Year column on the Report Periods tab will change to an inaccurate format when saving the report.  When the user opens the saved report and attempts to run the report, the user will receive the following errors:
  • ​Run-time error '0'
  • Run-time error '440'
  • Active X component. Can't create object


 

This was resolved in The Raiser's Edge 7.96, patch 4, released in May 2017 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.

This issue only occurs when YY is used as the Class of format in Config > Business Rules. Until this change is made in the software, the report can be run correctly by changing the Class of format in Configuration:

1. Navigate to Config > Business Rules
2. Select Alumni Options
3. Select "YYYY" from the "Class of format" section
4. Run the Comparisons and Summaries Report as needed

Steps to Duplicate

  1. Log into The Raiser's Edge
  2. Click Reports>Demographic and Statistical Reports
  3. Double-click on Comparisons and Summaries 
  4. On the General tab, select Include...>All records
  5. On the General tab, select Soft Credit Gifts To>Donor
  6. On the General tab, select Credit Matching Gifts To>MG Company
  7. On the General tab, mark Include these Constituents>Inactive constituents, Deceased constituents, Constituents with no valid address
  8. On the General tab, select Report Type>Summary
  9. Click the Fields tab
  10. Select Gifts>Months in the year from the Field to use tab
  11. Click the Filters tab
  12. Select the Filter Option drop-down in the Funds row
  13. Select Include selected
  14. Select your desired funds
  15. Click OK
  16. Click the Gift Types tab
  17. Select Period 1 from the Report period drop-down
  18. Select all gift types except Pledge, Write Off, MG Write Off, Recurring Gift, Gift-in-Kind, Pay-Gift-in-Kind, MG Pay-Gift-in-Kind, Other, Pay-Other, MG Pay-Other, MG Pledge
  19. Mark the Exclude zero amount gifts checkbox
  20. Select Period 2 from the Report period drop-down
  21. Select all gift types except Pledge, Write Off, MG Write Off, Recurring Gift, Gift-in-Kind, Pay-Gift-in-Kind, MG Pay-Gift-in-Kind, Other, Pay-Other, MG Pay-Other, MG Pledge
  22. Mark the Exclude zero amount gifts checkbox
  23. Select Period 3 from the Report period drop-down
  24. Select all gift types except Pledge, Write Off, MG Write Off, Recurring Gift, Gift-in-Kind, Pay-Gift-in-Kind, MG Pay-Gift-in-Kind, Other, Pay-Other, MG Pay-Other, MG Pledge
  25. Mark the Exclude zero amount gifts checkbox
  26. Select Period 4 from the Report period drop-down
  27. Select all gift types except Pledge, Write Off, MG Write Off, Recurring Gift, Gift-in-Kind, Pay-Gift-in-Kind, MG Pay-Gift-in-Kind, Other, Pay-Other, MG Pay-Other, MG Pledge
  28. Mark the Exclude zero amount gifts checkbox
  29. Select Period 5 from the Report period drop-down
  30. Select all gift types except Pledge, Write Off, MG Write Off, Recurring Gift, Gift-in-Kind, Pay-Gift-in-Kind, MG Pay-Gift-in-Kind, Other, Pay-Other, MG Pay-Other, MG Pledge
  31. Mark the Exclude zero amount gifts checkbox
  32. Click the Report Periods tab
  33. In the first row, select June from the Month drop-down
  34. In the first row, type 2015 in the Year field
  35. In the first row, type FY2016 in the Heading 1 field
  36. In the second row, select June from the Month drop-down
  37. In the second row, type 2014 in the Year field
  38. In the second row, type FY2015 in the Heading 1 field
  39. In the third row, select June from the Month drop-down
  40. In the third row, type 2013 in the Year field
  41. In the third row, type FY2014 in the Heading 1 field
  42. Click the Format tab
  43. Select the Headings option
  44. Type 3 Year month-to-Month Comparisons ALL GIVING in the Title field
  45. Mark the Print Organization name in header checkbox
  46. Select the Criteria option
  47. Mark the Print report criteria checkbox
  48. Select the Page Footer option
  49. Type RE>Reports>Demographic and Statistical Reports>Comparisons and Summaries>3-Yr-Month-to-Month Compari in the Text field
  50. Mark the Print Page Number in Footer checkbox
  51. Click Preview
  52. The report runs successfully and with the correct information
  53. Save the report and close the report
  54. Re-open the report
  55. Click on the Filters tab
  56. Notice that the Year column changes to the following format: 20160715, 20160714, 20160713
  57. Click Preview
  58. The following error appears:
  • Invalid procedure call or argument
  1. Close out of the report
  2. The same error appears
  3. Click on another tab in the report
  4. The following error appears: 
  • ​Run-time error '0'
  • Run-time error '440'
  • Active X component. Can't create object
  1. Force-close the report
  2. The following error appears:
  • The record is already open in another process.
 

Was this article helpful?