SQL Server - Spaces in field names

[scarmody]

I am having some difficulty with reports that I converted from an Access database to SQL Server using Crystal Reports 8.5. There are some field names in some of the tables that contain spaces. When I converted the report to SQL Server in the Report Designer it asked me to map these fields with spaces to their respective counterparts in the database which have square brackets around them. For example, Staff Name in the report got mapped to [Staff Name] in the database. I successfully ran the converted report and gave it to a friend who is running Crystal Reports 7.0 and the same exact database schema as well as the same version of SQL Server. He is now having trouble running those reports as it asks him to remap those fields (i.e. [Staff Name] to Staff Name). Does Crystal Reports handle these differently from 7.0 to 8.5? Any help would be appreciated.

 

[synapsevampire]

Once you've mapped and saved, it shouldn't ask again unless there's a difference.

Check closely, perhaps there's a subtle difference in the field names or types between the databases.

Perhaps a different ODBC driver might cause this problem too...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com