Can we use iReport using MSSQL Stored Procedure in Jaspersever

[asifisyed]

Hi,

We will use MSSQL stored procedure to generate report using iReport. Can these reports be deployed in Jaspersever?

Is there any tutorial available  how to call MSSQL stored Proc from iReport. Are there any criteria of Stored-Procedure which statifies iReport?

 

Thanks.

Asif

[gdmoreno]

 Yes, you can call MS SQL stored procedures from iReport. When you deploy that report to the server, the server will execute the stored procedure and use the result set to fill in the report.

here's the process:

- create your stored procedure

- in iReport, when defining the report query, choose plsql

- in the query, write the call to the stored procedure by its name - <stored_procedure_name> [parameters]

- You can preview the data that the procedure returns right there by hitting the "Refresh Preview Data"

Once you've gotten to this point, you can go ahead and design the report in iReport as you normally would. When you're done and ready to deploy it to the server, you'll just use the repository navigator to upload it.