Symptom: 

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


Cause: 

Report was saved with a Merge Field definition, that has since been deleted from system.  

Resolution: 

Navigate to Options tab of report and select and save a new set of Merge fields.

 

Additional Information: 

The resolution of selecting a new set of merge fields would also apply if the error message received is:

Select Error - column lists do not match

Required Tags:

Article Type: 
Product Info
Product Line: 
Fundraising 50
Product Module/Feature: 
Reports
Ranking: 
0
No votes yet