Error: "A field in the dataset 'AdhocQuery' has the name '1234NAMEOFQUERY'. Field names must be CLS-compliant identifiers.

When trying to Create a report from Ad-hoc Query that uses smart fields that are named with numbers in the beginning the report fails with error.

SQL server does not allow column names with numerals.  Change the name of the column to something that begins with an alphabet character.  
 

For more info, consult:
https://social.technet.microsoft.com/Forums/sqlserver/en-US/154c19c4-95ba-4b6f-b6ca-479288feabfb/characters-that-are-not-allowed-in-table-name-column-name-in-sql-server-?forum=databasedesign

Steps to Duplicate

Steps to duplicate: 
1. Log into sample
2.Go to Information Library
3.Click on Constituent Query that is built including smartfield with numbers beginning name
4.Click tab Create
5.Click Report
6.Enter any name for Report from Ad-hoc Query and then click Create
7.Notice error 
 
 

Environment

 Blackbaud CRM
 4.0
 4.0.170

Was this article helpful?