Knowledgebase Search

Even though a defined field was used in a Financial Report query, all of constituent's transactions appear in the report rather than just those specified in the defined field parameters.

No matter how I create my query,  the system returns Constituents who have given gifts or attended an event even though my query clearly states Solicitation or Event is NOT equal to  XXXXX.

Error received when running Analytical Report: Upgrade Downgrade in Annual Donors:

The following reports experience inconsistent output results when the Constituent ID or Constituent Name fields are added to the output fields:
 
Custom Constituent Export
Custom Gift Export
Custom Pledge Payment Reminders
Custom Volunteer
Custom...

Upgrade/Downgrade report returns no data when the Fiscal Year month is greater than the current month.

When querying for any record in the database the following message is returned:

Select Error: SQLSTATE=S0022

[Microsoft][ODBC SQL Server Driver][SLQ Server]Invalid column name ‘email_alt’

 ...

After upgrading to v2014 running saved reports created from Donor Statement in prior versions returns:

Error Number: 39
Error accessing external object property val at line 29 in function nf_get_val of object n_report_format.
 ...

Select error: Incorrect syntax near the keyword ‘UNION’ is received when running saved report with multiple groups created from Custom Constituent Export File. 

Activation Error:  Printer not activated, error code -41   received when printing to PDF

When Defined Fields created from Last Registration Date…are added to Options in the Custom Gift Export File Report the following message is returned:
 
SyntaxFROMSQL caused these errors: SQLSTATE=37000 [Microsoft][OSBC SQL Server Driver][SQL Server] The multi-part identifier ‘event...

Receipt Reports are inserting blank pages into report preview or when sent to printer

Pledge Payment Reminder List Report/Total Due Payments on this report is not matching the total amount paid in donors records.