blackc2004
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by blackc2004
-
How to write sql statements with tables using reserved words
blackc2004 replied to blackc2004's topic in Products
Hi there, we're using MSSQL as our database. The table names are enclosed in [. But the iReport seems to remove them when wringing the query. -
Hello, I am trying to get started using iReport Designer and hopefully someone can help me out with this question. Our database is Microsoft Dynamics NAV and all the tables have special chars in them, such as this: Company Name$Table Name In SQL my query is SELECT * FROM [Company Name$Table Name] However when I do this in iReport query it removes the brackets. How can I write queries with these special chars?
