tcrooks0904 Posted February 28, 2014 Share Posted February 28, 2014 I've created a stored Query in Jasperserver that calls: EXEC store_procedure_name. I've also created an Input Control (Single-Select Query) that uses that Repository based Query that I just created as the basis. The issue I'm having is that no matter which way I setup the Query and Input Control, it will not load the Input Control when I view the report and will actually cause all Input Controls on that report (I have 5) to not load at the top of the report either.The only success I've had with this is by changing the Query from calling a stored procedure to calling the actual query that is contained in the stored procedure. So instead of EXEC stored_procedure_name, I have the Query defined as SELECT * FROM dbo.table WHERE etc, etc, etc.Can Jaspersoft/Jaspserserver not handle calling stored procedures via queries/input controls? That is my only guess at this point since the query itself will run just fine if no stored procedures are involved. Link to comment Share on other sites More sharing options...
M.S.Evans Posted March 17, 2015 Share Posted March 17, 2015 I had the same issue. I'm using Table Valued Functions which seem to work fine. Good Luck 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