blackc2004 Posted June 21, 2013 Share Posted June 21, 2013 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 NameIn 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? Link to comment Share on other sites More sharing options...
Thomas Zimmer Posted June 22, 2013 Share Posted June 22, 2013 I don´t know exactly how to do with MS Dyn... but the different databases use diferent text enclosuring.I think you could try to use the query designer in iReport to createa simple sql, then look how the tablenames are enclosed (i would assume " or ')Cheers, Thomashttp://www.thomaszimmer.net Link to comment Share on other sites More sharing options...
blackc2004 Posted June 22, 2013 Author Share Posted June 22, 2013 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. Link to comment Share on other sites More sharing options...
Thomas Zimmer Posted June 23, 2013 Share Posted June 23, 2013 Did you try to create a simple query with the query designer in iReport? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now