SQL Server Table Names With Periods (.)

Stimulsoft Ultimate discussion
Post Reply
jdempsey@kahua.com
Posts: 28
Joined: Tue Oct 04, 2011 7:13 pm
Location: USA

SQL Server Table Names With Periods (.)

Post by jdempsey@kahua.com »

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
ReportWizard.png (55.17 KiB) Viewed 1383 times
ReportWizardError.png
ReportWizardError.png (38.64 KiB) Viewed 1383 times
Ivan
Posts: 960
Joined: Thu Aug 10, 2006 1:37 am

Re: SQL Server Table Names With Periods (.)

Post by Ivan »

Hello,

The problem is solved.
The patch will be available in the next prerelease build.

Thank you.
Post Reply