meyerjj Posted July 30, 2009 Share Posted July 30, 2009 I am currently trying to setup connctions in iReport to both an Oracle database and a SQL Server 2005 database. I have successfully created the connections and they connect properly. My problem arrises when I try to create a report in the Teport Wizard. When I open the query designer, the list of items in the first drop down list is usernames and not schemas as I would expect. With a Postgresql connection this works as I would think in that you can choose the schema. Has anyone else had a similar problem or am I doing something wrong?Thanks,Jeff Link to comment Share on other sites More sharing options...
Giulio Toffoli Posted July 31, 2009 Share Posted July 31, 2009 Can you post a screenshot? Are you sure you have not a schema per each user in your db?Giulio 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