Hello, I have created a report which the report query has the bellow structure:
EXEC Proc_NAME parameters
When I run the report by clicking 'Preview' from the ireport, the stored procedure is executed.
When I run the report from jasperserver, the stored procedure is not be executed but the report is exported.
Also, the stored procedure does not return anything.
Calling stored procedure is a seperate request - It is not included on the select statement.
I am wondering why on preview on iReport the stored procedure is executed and on jasperserver is not executed.
Is there any configuration that I have to do? Do you have any suggestions how to fix this?
Thanks in advance.