Filling crosstab with JRBeanCollectionDataSource

[zbd]

Hi, guys. I'm trying to fill crosstab with JRBeanCollectionDataSource, but I have some problems.

 

So, i have a simple crosstab created with iReport:

 

-----------------------------------------------------------

|---------------------|-$V{rowHeader}-|---------------|

-----------------------------------------------------------

|--$V{colHeader}--|--$V{crValue}----|-----------------|

-----------------------------------------------------------

 

I'm trying to fill report passing the collection of beans. Bean has 3 fields: rowHeader, colHeader and crValue for each variable of crosstab. But during report filling I throws into exception:

 

Exception in thread "main" net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset

at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:654)

at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:169)

at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:152)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:604)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:229)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:751)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:679)

at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601)

at POCReport.main(POCReport.java:29)

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:650)

... 10 more

 

How should I properly fill crosstab using JRBeanCollectionDataSource?

 

P.S. Thanks for your help!

Post edited by: zbd, at: 2007/01/12 17:59

[bklawans]

That's discussed in the FAQ - http://jasperforge.org/sf/wiki/do/viewPage/projects.jasperreports/wiki/FAQ17

 

 

You probably need to either move the crosstab to the summary section or create a subdataset.

 

-Barry

Post edited by: bklawans, at: 2007/01/12 22:37

[zbd]

Hmmm... Neither of two decisions helps me...

The crosstab doesn't fills or I have exceptions in different situations.

Guys, did anybody use JRBeanCollectionDataSource for crosstab filling? Please, help me with my simple crosstab!

Thanks!

[shizhengyao]

i hava same problem,who has same examples?

[xourge]

moving to summary worked just fine, thanx a lot :)