Jaspersoft Report using SQL Server Stored Procedure

I have a stored procedure named P1.

I want to create a Jaspersoft report using the result of p1 assume p1 returns a result set.

p1 has set of parameters.

I don't know how to create report using stored procedure and how to pass parameters to my report.

Please guide me the steps to do this or correct me what I am missing here.

Solution

Its possible to execute stored procedure with parameter in Jasper report. U must set your report's Query Language to Plsql first. Please refer this guide ireport-calling-stored-procedures

If u still have problem, i can show some example here.

Passing stored procedure arguments to FOR loop cursor
Returning boolean from SQL function
Update multiple columns based on values of another table in stored procedure
Is it possible to determine what caused a duplicate key values
sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible'
Passing a table name as a variable to Snowflake stored procedure
Can't drag stored procedure onto dbml designer
Return Stored Proc Results in CTE
Only members of the sysadmin fixed server role can perform this operation. Azure SQL Server Database vs SQL Server Database
What does the new stored procedure default content mean?
Pass table columns as arguments into Teradata SQL stored procedure
Why is DELETE FROM vehicle_data WHERE NOW() > expires_at; failing in my stored function?
How to handle the exception in Snowflake SQL scripting stored procedure with return type as TABLE
How to debug a SP response in Quarkus using EntityManager
Does the prepared SQL statements in a stored procedure make the performance better?
Return multiple ref cursors in single OUT parameter of stored procedure
Stored Procedure for Deleting in Chunks - LOOP not executing
SQL Stored Procedures not finishing when called from Python
How to compare values which may both be null in T-SQL
Data not getting updated via stored procedure in Oracle
How do I resolve SnowparkSQLException: ... User is empty in function for Snowpark python SPROC invocation?
Why must some stored procedures in MSSQL be called with `master..` prepended while other can be called without it?
T-SQL - stored procedure - "IF EXISTS" vs. "WHERE EXISTS"
How to pass NULL Value to Stored Procedure Through C#
How to get values from another stored procedure and insert it into the temporary table in one stored procedure in MySQL?
How to renumber the field value in SQL using SQL script
EF6 Stored Procedure does not accept parameters
SQL condition based on variable value
T-SQL stored procedure - error inserting the last variable
Azure Data Factory - Null parameter in stored procedure activity