SQL Server Table Names With Periods (.)
-
- Posts: 28
- Joined: Tue Oct 04, 2011 7:13 pm
- Location: USA
SQL Server Table Names With Periods (.)
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?
- Attachments
-
- ReportWizard.png (55.17 KiB) Viewed 1385 times
-
- ReportWizardError.png (38.64 KiB) Viewed 1385 times
Re: SQL Server Table Names With Periods (.)
Hello,
The problem is solved.
The patch will be available in the next prerelease build.
Thank you.
The problem is solved.
The patch will be available in the next prerelease build.
Thank you.