Shazia

Try using report group and group variable for cumulative sum with appropriate group properties - calculation type as SUM, reset type as group etc.

Not sure if this is the problem but please edit Subreport Expression as $P{SUBREPORT_DIR} +File.separator+"YourReportName.jasper" and check once.

Edit the text field expression to $F{ref_num}==null?'0':$F{ref_num} This will display ref_num value when present and if null then zero will get displayed.

You can use the below condition in where clause which will solve your problem, SELECT * FROM ORDERS WHERE ORDER_TYPE_ID = $P{my_order_type_id} AND ORDER_Company_ID like DECODE($P{my_order_company_id},'','%','0','%',$P{my_order_company_id});

Agree with Shertage. Return variable is not required since 'Office' field is directly displayed in subreport itself. Remove the data source expression and do as Shertage's suggestion. Also, try $P{REPORT_CONNECTION} parameter in connection expression and connection type by default as 'Use a connection expression', Datasource expression as blank.

Use a page break element after cross tab and before subreport. Subreport details will print in the next page. Alternatively, you can also use element property - Position Type and Stretch Type.

Can this be included in jasperreports.properties or at iReport designer level? Please guide.

Please ensure the return variables from sub reports in main report have evaluation time set as Band.

Use the below in your query where clause - where $X{IN, DBField ,CollectionParameter} I have been using this since long, works fine.

DB parameter CURSOR_SHARING as 'Force' is affecting report generation. I have found that providing a hint /*+CURSOR_SHARING_EXACT */ in report queries will resolve this issue. However, revisiting all jrxmls which are over 1500 files is not a suitable option. Could anyone please guide as to how this can be generalised as a property in iReport which would eventually reflect in all reports? Thanks and Regards, Shazia Gulsheen

Thank you so much Hozawa for your prompt response. It was the latest orcale jdbc driver used when this issue was identified. I am still facing the same issue.

Hello, Jasper reports - designed in iReport and integrated with the application which were perfectly running fine have stopped suddenly. Error thrown is as given below. However, post changing the Datbase parameter - CURSOR_SHARING to 'Exact', the reports have started working again. For performance reasons the parameter CURSOR_SHARING was changed to 'Force'. Since the reports stopped working, reverting to 'Exact' has resolved the issue. Is there a dependency of jasper reports on CURSOR_SHARING with value as Exact? Field in the select statement of the query is in the format - (nvl(trim(to_char(E.Intrst_Dcml_Rate,'99990.0000000')),0.00)||' '||'% p.a.') and NVL(SUM(QTY),0) which is either mapped to a subreport parameter or is directly printed in the detail band. Request you to please let me know if there is something else which has caused the issue. Could this be addressed sooner please? Error : Error filling print... net.sf.jasperreports.engine.JRException: Unknown column name : NVL(SUM(QTY),0) net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Unknown column name : NVL(SUM(QTY),0) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:809) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:332) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:384) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:358) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:2069) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:788) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:298) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:152) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87) at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:287) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:760) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:891) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: net.sf.jasperreports.engine.JRException: Unknown column name : NVL(SUM(QTY),0) at net.sf.jasperreports.engine.JRResultSetDataSource.getColumnIndex(JRResultSetDataSource.java:409) at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:139) at net.sf.jasperreports.engine.fill.JRFillDataset.setOldValues(JRFillDataset.java:1358) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1259) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1235) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1614) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:150) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:963) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:665) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Print not filled. Try to use an EmptyDataSource... Thanks and Regards, Shazia Gulsheen