crosstab report -error

[mortoza]

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 attaching my .jrxml report and error report-

 

Compiling to file... D:inteaccreportsOeProductSalesPerSalesCentre.jasper -> C:iReport-1.2.6OeProductSalesPerSalesCentre.java

it.businesslogic.ireport.ReportClassLoader@10d6ca2Â

Compilation running time : 344

ÂFilling report...

ÂLocale: English (United States)

ÂTime zone: default

ErrorÂfillingÂprint...

net.sf.jasperreports.engine.JRException:ÂCrosstabÂdataÂhasÂalreadyÂbeenÂprocessed. ÂÂÂÂatÂnet.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java: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.java: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(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java: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.java: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(JRFillCrosstab.java:646) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java: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.java: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(BucketingService.java:286) ÂÂÂÂatÂnet.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:642) ÂÂÂÂ...Â12ÂmoreÂ

PrintÂnotÂfilled.ÂTryÂtoÂuseÂanÂEmptyDataSource...!

 

Look forward for helo.

Best regards,

Mortoza [file name=OeProductSalesPerSalesCentre.jrxml size=14927]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/OeProductSalesPerSalesCentre.jrxml[/file]

[Teodor Danciu]

Hi,

 

There is an FAQ for this here:

http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ17

 

I hope this helps.

Teodor

[mortoza]

Hi Teodor

Thanks. I have already resolved this issue. Now I have some other issues in crosstab report. I have posted this in iReprot section.

 

Thanks for the help.

Mortoza