Crosstab

[debchat1955]

I had added one column, one row and one measure.

 

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset.

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:511)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:486)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:367)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

Caused by: net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset.

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

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

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

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

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

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

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

at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:119)

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

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

... 8 more

 

[debchat1955]

http://community.jaspersoft.com/wiki/tables-and-crosstabs-jaspersoft-studio

I used Sample DB and here also I get the same error -

Column = Shipdate

Row =Shipcountry

Measure = OrderID

I get error as soon as I click on preview.

 

[debchat1955]

Using Jaspersoft Studio Version 6.1.1

[debchat1955]

I get some success when I add crosstab into "summary" section.

But the result shows too many pages.

I need to check data and troubleshoot.

[debchat1955]

Also see Issue 6656

[debchat1955]

I took advise of Tech Support and could remove "detail" section of report.

Things work properly now.

Thank you