MK_Tracker

HI, Could someone from the JasperSoft confirm if we can call a MS SQL Server stored procedure from a report which creates few temp tables ? The situation is, I am currently evaluating the Jasper Reports for my organization and to reduce the time I am using the existing stored procedures and calling them from the Report. I am using JasperSoft Studio. Also using query within 'PLSQL' . But these stored procedure are havily using temp tables creation within them. I read somewhere that the stored procedures using temp table wont return any data. I spent a lot of time modifying these stored procedures to replace the temp table with temp variables. But eventually the result is same. :( When I call these stored procs I am getting the below error, net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : STORED PROCEDURE NAMEat com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:467)at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:442)at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:334)at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : STORED PROCEDURE NAMEat com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:115)at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119)at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691)at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434)at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508)at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:120)at java.lang.Thread.run(Unknown Source)Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:408)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:110)... 6 more

Hi, I am trying to call MSSQL Server stored procedure from a report I am trying to create using Jaspersoft Studio Professional. I followed the instructions given in this link(http://community.jaspersoft.com/wiki/calling-microsoft-sql-stored-procedures-ireport), but am still haveing issues. A step by step instructions would really help. I am calling the stored proc as below with language as plsql, sp_name $P{param1}, $P{param2}, $P{param3}, $P{param4}, $P{param5} When I run the 'Refresh Preview Data' I am getting the error message as, 'The statement did not return a result set'

HI, I have been asked to look for a report engine to integrate in to one of our products which is based on ASP.NET MVC. I ahve been trying Jasper reports from last 1-2 days. Could you please help me in understanding the way we can integrate this in to ASP.NET MVC application ? An example would really help in this regard Thank you