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
Article Type
Product Info
Product Line
Fundraising 50
Product Module/Feature
Reports
Ranking