nairit91 Posted July 21, 2017 Share Posted July 21, 2017 Hi,I'm looking forward to use Oracle Stored Procedure to create a Domain in Jasper Reports Server and thereafter create a Ad Hoc View from that Domain. However, i'm unable to find the stored procedure while loading the db schema inside the domain designer. Kindly help.N.B: I'm a licensed user of the Enterprise Edition of JRS and the difficulty related to Stored procedure has stalled implementation of our project. Link to comment Share on other sites More sharing options...
Friendly User Posted July 24, 2017 Share Posted July 24, 2017 You can create a domain based on tables from data source connection and not stored procedure. You can use stored procedure in an ad hoc topic to return fields you want and then build ad hoc view based on the topic. To create a topic simply create a JRXML with a stored procedure call and then upload that JRXML to the server /ad hoc components/topics location.If you're a licensed user and your implementation is stalled you probably should contact support instead. 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