harishb

I created one Jasper report in using jasper studio and published into the jasper report server. But need to access that report and to show into asp.net mvc application. I went through the different reference links but didn't find the proper way to integrate the jasper report into mvc application. Can anyone help through to get out this issue? When calling the report from postman like below http://localhost:8080/jasperserver/rest/reports/reports/RMSReports/SalesRegisterReport.html?prams_RouteId=1&parms_CreateDate=11-21-2019 i am getting 404 error.

After adding like that i am getting error like below <queryString language="plsql"> <![CDATA[call SalesRegisterReport ($p{parms_Id},$p{parms_date})]]> </queryString> net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: SalesRegisterReport. at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:551) at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$18(ReportController.java:526) at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:444) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: SalesRegisterReport. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:357) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:578) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135) at java.lang.Thread.run(Thread.java:748) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '$p' in 'field list' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) at com.mysql.jdbc.Util.getInstance(Util.java:408) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2675) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1912) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2020) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:312) ... 6 more

After creating the report. When selecting data source there mentation my SP Call with default values. But when i passing the other parameters i am not getting new data-based on the parameters it is showing the same data without respective the parameters of we are giving. I found something wrong behind the query string having the constant parameters like below <queryString language="plsql"> <![CDATA[call SalesRegisterReport (2,'2017-07-17')]]> </queryString> how can make that parameters dynamic. I added the parameters in the Parameters section and how can i make page nation to this report. when i pass like below it's getting error <parameter name="parms_Id" class="java.lang.String"/> <parameter name="parms_date" class="java.lang.String"/> <queryString language="plsql"> <![CDATA[call SalesRegisterReport ($p{parms_Id},$p1{parms_date})]]> </queryString>