meyerjj Posted July 2, 2015 Share Posted July 2, 2015 We have an Oracle data source that we report against where all of the "tables" are referenced using public synonyms. When creating reports using JasperSoft Studio and iReport we are unable to use the query deisgner because it can't load the public synonyms. In these tools we can get around this by writing straight SQL. Unortunately, we do not have this option when using the Domain Designer in JasperServer. I have set the "includeSynonymsForOracle" to true in the server configuration but this doesn't make an difference for the public synonyms because they are not part of a schema. Is there a way to access public synonyms in the doamin designer on JasperServer?Thanks. Link to comment Share on other sites More sharing options...
Solution hozawa Posted July 5, 2015 Solution Share Posted July 5, 2015 You'll have to use Derived Table and enter SQL statement from there. 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