JasperServer - MSSQL Stored procedures

Hello, I have created a report which the report query has the bellow structure:


FROM ...



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.


elenamichael_cy's picture
Joined: Mar 1 2016 - 8:48am
Last seen: 7 years 6 months ago

0 Answers:

No answers yet