SQL Server Table Names With Periods (.)
Posted: Thu Apr 23, 2015 9:20 pm
When you use your report wizard to generate a report and the datasource (using MS SQL Server) has a table with a period it in (i.e. "kahua_CompanyManager.kahua_Company") it results in an error when you try and run the report (screenshots attached). To fix the problem you have to edit your datasource and put brackets around the table names (i.e. "[kahua_CompanyManager.kahua_Company]"). Have you guys ever considered putting brackets around the table names in the "SELECT * FROM [...]" SQL statements that you generate?