The statement did not return a result set

[Portlight]

using mssql 2008

I have a stored procedure which i am using to build a report.

The procedure works within the query analyzer, is returns the expected data, however when I use this query in a iReport - and try to run the report i get the following error:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:392)      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:338)      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)      at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)      at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:281)      at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:222)      ... 11 more

I have set NOCOUNT ON;

In the stored procedure - any ideas

[Raphaël Peguet]

Hi Suki,

 

I'm not very familiar with stored procedures but there is some hints on this page http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=65834

 

Hope this helps,

 

Raphael

[fernando2k3]

Insert After you Begin in your PL 

"SET NOCOUNT ON"

example:

---

USE [GPEXT]
GO
CREAT Proc [dbo].[EXAMPLE] 
@year char(4),
@month char(2)
AS

SET NOCOUNT ON

---

Hope this helps

Luis