Knowledgebase Search

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.
 ...

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.

Events Reports-List of Guest by Event-Unduplicated displays attendee name incorrectly.  It is shown as lastname;firstname under attendee
 

The Solicitation Results by Campaign report does not return results in a timely manner when the query contains only a date range.
 

Error received when running Export to GL: Export Solicitation ID not valid

When saving the Pledge Payment Reminders List report the following message is returned.

SQLSTATE = 22001
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be...

Access MIP Fund Accounting
Select Transactions>Enter CR
You will see that the two transactions are entered as a single four line transaction with a net value of the deleted gift plus the new gift
 ...

When running either a new or saved report the following error message is returned:
                          
Error Number: 4104
Message: Select Error: SQLSTATE=37000 [Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier “name.lastname” could not be bound...

The system allows for the same Attribute Category to be selected multiple times.  When the user saves the report by selecting the Save button the report disappears from the report menu. 

When you query in SQL Management Studio using select * from re_report order by name, the report...

When attempting to save a report or query containing a Defined Field where the name exceeds 40 characters the system returns:



SQLSTATE = 22001
[Microsoft][ODBC SQL Server Driver][SQL Server]...

Choosing “Updated Date” and “Origin” in the same query causes Error Number: 207 Select Error: SQLSTATE = S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name ‘updated’. Window: dialog   Report returns no data.
 

One Receipt per Gift and Itemized Receipts per Constituent print in Landscape when ‘Print Eligible Amount’ is selected on the Options tab

When running a report, if the Operator Contains is used on Basic or Name card, the report does not return all of the results

Proposal List Report is missing the following fields in its export file:

• Next_Step_name or proposal_step_name

• Solicitation

Change Record type feature in the navigator, to change an Org type record to Ind type, system returns a message that the Contact name card must be removed.  Attempt to delete the contact name card, system erroneously returns message that you cannot delete the only name card with the Include in...

Symptom/Current result: Query criteria on other fields from the gift card have no result on the report 

Expected result: All query criteria should be utilized by the report when it compiles in order to return correct results.
 

The query allows values in the Receipt Type field to be selected multiple times

Report gives error but then it will allow you to run the report, however the data is not what was selected and it turns into one constitute per page.

Actual Receipt amount (gift minus benefit received) does not display on report.  Since this is a Receipt report, it should accurately display the receipt or eligible amount that was issued a constituent

Home > Dashboard Report > MTD Comparison by Fiscal Year Bar Graph displays Year to Date Totals rather than Month to Date Totals
 

Navigator > Reports > Financial > First, Largest, Last Gift report does not sort properly when first gift date or last gift dates are chosen as a sort option.



...