ktzeng

The parameters of 2 subreports aren't being passed through correctly through the master report. I have 3 other subreports and the parameters are all working correctly. My parameters through the master report and subreport are $P{swap_book} and $P{risk_group_name}. The only difference is that these aren't fields in the master report, just parameters. These are all added as subreport parameters in the master report. Any suggestions? SwapsByTrade and SwapsByTradeCurr are the subreports that aren't working. Thanks. [file name=SwapsReport.jrxml size=30047] Post edited by: ktzeng, at: 2008/07/11 17:39

Is there any way to return a total in a crosstab in a subreport to the master report?

I tried that, but no results seem to be created. Any other suggestions?

I'm trying to pass a simple parameter through a query. My query reads select CURR_CODE, VAR as VAR1, 0 VAR2 from rm_var_group_details v, rm_bu_rg_details r where v.group_type = 1 and v.var_type = 'VAR10DAY99' and v.idx_id = r.idx_id and r.risk_group_name = $P!{risk_group_name} and r.business_unit = 'ipb' and r.cob_date = (select max(rundate) from business_day where date_type = 'COB') If I'm prompted for risk_group_name, I type TESTGROUP2, and it creates this error. ErrorÂfillingÂprint...ÂErrorÂexecutingÂSQLÂstatementÂforÂ:ÂSwapsÂReport net.sf.jasperreports.engine.JRException:ÂErrorÂexecutingÂSQLÂstatementÂforÂ:ÂSwapsÂReport ÂÂÂÂatÂnet.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:121) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:673) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setDatasource(JRFillDataset.java:610) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:599) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:864) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:702) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:660) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:234) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:808) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource) CausedÂby:Âjava.sql.SQLException:ÂORA-00904:Â"TESTGROUP2":ÂinvalidÂidentifier  ÂÂÂÂatÂoracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) ÂÂÂÂatÂoracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289) ÂÂÂÂatÂoracle.jdbc.ttc7.Oall7.receive(Oall7.java:573) ÂÂÂÂatÂoracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) ÂÂÂÂatÂoracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830) ÂÂÂÂatÂoracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391) ÂÂÂÂatÂoracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672) ÂÂÂÂatÂoracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589) ÂÂÂÂatÂoracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527) ÂÂÂÂatÂnet.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:115) ÂÂÂÂ...Â11Âmore Print was not filled. Try using an EmptyDataSource... However, if i hardcode 'TESTGROUP2' into the query the report works. Any suggestions? risk_group_name is a string. Thanks! Post edited by: ktzeng, at: 2007/01/30 19:39