How to use MSSQL stored procedure in iReport

[asifisyed]

Hi,

I have been googling to find out a tutorial how to call MSSQL stored Proc from iReport but couldn't find any. I would be grateful If someone helps me regarding this. I was trying with some sample stored procedure, ireport shows SP does not return any result set.

Does this mean , SP must have OUT parameter. What are the criteria of Stored-Procedure which statifies iReport.

 

Thanks.

Asif

[cmatthews]

 

I use them all the time, should work without any extra effort.

EXEC DBNAME.owner.usp_ShowSomething '$P!{someParameter}'

No out parameter should be needed, whatever your final select is in the procedure should be available to jasper/ireport as data.

The simple sample SP I put in the code section works for me,

 

 

Code:

CREATE PROCEDURE usp_ShowSomething	@someParameter VARCHAR(MAX)ASBEGIN	SET NOCOUNT ON	SELECT 'This should show your parameter: ' as column1, @someParameter as column2END