mortoza Posted October 15, 2006 Share Posted October 15, 2006 Hello,I have prepared a crosstab report. I can successfully compile the report in iReport but while I try to run the report, it is giving following exceptions. Can someone help me? I am also attaching my .jrxml report- Compiling to file... D:inteaccreportsOeProductSalesPerSalesCentre.jasper -> C:iReport-1.2.6OeProductSalesPerSalesCentre.javait.businesslogic.ireport.ReportClassLoader@10d6ca2 Compilation running time : 344 Filling report... Locale: English (United States) Time zone: defaultError filling print... net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:646) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.jav a:169) at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:154) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:621) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.jav a:248) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:132) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:758) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:666) 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:752) at java.lang.Thread.run(Unknown Source) Caused by: net.sf.jasperreports.engine.JRException: Crosstab data has already been processed. at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingServic e.java:286) at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JR FillCrosstab.java:642) ... 12 more Print not filled. Try to use an EmptyDataSource...! Look forward for help.Best regards,Mortoza [file name=OeProductSalesPerSalesCentre-a57f73abd4c3e6d85638dee7a50e942b.jrxml size=14927]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeProductSalesPerSalesCentre-a57f73abd4c3e6d85638dee7a50e942b.jrxml[/file] Link to comment Share on other sites More sharing options...
mortoza Posted October 15, 2006 Author Share Posted October 15, 2006 HelloI have reset the dataset at group level (here it is prodId) and could run the report BUT, I do not get the colums dynamically created and total per record (rows) is unexpectedly appeared. Can anyone help? I attache herewith the updated .jrxml report and output in .pdf for your reference. Thanks in advance for the help. Rgds,Mortoza [file name=crosstabReport.pdf size=82359]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/crosstabReport.pdf[/file] Link to comment Share on other sites More sharing options...
lucianc Posted October 16, 2006 Share Posted October 16, 2006 If you reset the dataset at group level, you would usually want to place the crosstab in the group footer. I see from you JRXML that the crosstab is placed in the detail band, which doesn't make much sense. HTH,Lucian Link to comment Share on other sites More sharing options...
mortoza Posted October 17, 2006 Author Share Posted October 17, 2006 Dear LucianThank you for your attention. I have prepared another report by now not resetting at group level but at report level. I have placed the crosstab component in detail band. It is working fine. Now I have another requirement. I want to add additional column with row groups e.g. customer name, address etc. I am getting null value in the report. Hope you will help.Regards,MortozaPost edited by: mortoza, at: 2006/10/17 20:21 Link to comment Share on other sites More sharing options...
lucianc Posted October 18, 2006 Share Posted October 18, 2006 I don't think I understood what you are trying to do. Can you post specific information, including relevant JRXML fragments, expected output, actual output, etc.. Regards,Lucian Link to comment Share on other sites More sharing options...
mortoza Posted October 22, 2006 Author Share Posted October 22, 2006 Hello1) I have fixed the null value by now.. but My point is how can I get additional columns without putting them in row-group. for example I have added customer name with customer ID under sales person group. While the customer ID is of fixed width for all customers, the report will look OK but when any one ID will have different number of character width then the customer name column will be displayed at a different position. My question is how can I get dynamic columns, rows (crosstab) in combination with simple row/columns? 2) How do I put '0' in missing columns for those rows where there is no value and put the total Column aligned right. I attach herewith my .jrxml and .pdf files. Best regards,Mortoza [file name=OeSalesReportCustSpScCrossTab.jrxml size=19384]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeSalesReportCustSpScCrossTab.jrxml[/file] Link to comment Share on other sites More sharing options...
mortoza Posted October 22, 2006 Author Share Posted October 22, 2006 Hello1) I have fixed the null value by now.. but My point is how can I get additional columns without putting them in row-group. for example I have added customer name with customer ID under sales person group. While the customer ID is of fixed width for all customers, the report will look OK but when any one ID will have different number of character width then the customer name column will be displayed at a different position. My question is how can I get dynamic columns, rows (crosstab) in combination with simple row/columns? 2) How do I put '0' in missing columns for those rows where there is no value and put the total Column aligned right. I attach herewith my .jrxml and .pdf files. Best regards,Mortoza Link to comment Share on other sites More sharing options...
mortoza Posted October 22, 2006 Author Share Posted October 22, 2006 Hello1) I want additional columns which would be not part of row groups. For example, to work around, I have included the customer name joining with customer ID. In this case the disadvantage is the customer ID is not always having fixed width. 2) Can I put '0' value to those rows where there is no value for some columns? This will allow me to get the 'Total Column' aligned.Regards,Mortoza [file name=OeSalesReportCustSpScCrossTab-a92f007a6ef20d64b2ea06a2278ee3ea.jrxml size=19384]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeSalesReportCustSpScCrossTab-a92f007a6ef20d64b2ea06a2278ee3ea.jrxml[/file] Link to comment Share on other sites More sharing options...
mortoza Posted October 22, 2006 Author Share Posted October 22, 2006 I am attaching the .pdf report file.Rgds,mortoza Link to comment Share on other sites More sharing options...
lucianc Posted October 24, 2006 Share Posted October 24, 2006 I can't see the PDF. Can you attach it again? Regards,Lucian Link to comment Share on other sites More sharing options...
mortoza Posted October 26, 2006 Author Share Posted October 26, 2006 Hello LuciancThe original file was big, I have cut page 1 and made a new file for you. Awaiting your support.Rgds,Mortoza [file name=salesReport2.pdf size=54092]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/salesReport2.pdf[/file] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now