I have a very simple MS SQL stored proc (no input parameters). See below...
CREATE PROCEDURE dbo.Test
SET NO COUNT ON
SELECT * FROM person
When I use this stored proc as my data source in JasperReports Studio building my report, everything works perfectly. But when I upload it into JasperReports Server and setup the relevant data sources there, I keep getting an error when the report tries to run.
Any help/guidance is appreciated. P.S. I'm using the Community Edition of JasperReports Server 6.4.0.
you will need to add some more info here, please.
What is the error you are getting.
I would suggest finding the error in the log file and then posting the whole stack trace error, so one can maybe identify where the error is occuring.
There could be a lot of reasons why this is not working as expected.