Cross Tab Error

[ravichoudhary]

Hi all,

I am using iReport 3.7 for report.

My report query is a mdx query as follows.

SELECT
    {[Measures].[internet Sales Amount] ,[Measures].[internet Tax Amount]} ON COLUMNS,
     { [Geography].[Country].[Country]} ON ROWS
    FROM [Adventure Works]

I have created a cross tab to show query data in report. i have add Country in row group and Internet Sales Amount in column group but it is giving following error.

Error filling print... Error incrementing crosstab dataset net.sf.jasperreports.engine.JRRuntimeException: Error incrementing crosstab dataset      at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:733)      at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:175)      at net.sf.jasperreports.engine.fill.JRCalculator.incrementDataset(JRCalculator.java:394)      at net.sf.jasperreports.engine.fill.JRCalculator.initializeVariables(JRCalculator.java:278)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillPageBreak(JRVerticalFiller.java:1908)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBreak(JRVerticalFiller.java:1940)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:724)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportContent(JRVerticalFiller.java:272)      at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:114)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:119)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:970)      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: Crosstab data has already been processed.      at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.addData(BucketingService.java:300)      at net.sf.jasperreports.engine.fill.JRFillCrosstab$JRFillCrosstabDataset.customIncrement(JRFillCrosstab.java:729)      ... 15 more  Print not filled. Try to use an EmptyDataSource...

 

I have also tried increment option of crosstab - crossdata section but my issue not resolved.

Please help me.?

--

Thanks & Regards,

Ravi Choudhary

[kchaudhry]

What band did you place your cross tab in? Try moving it to "Summary" band and the error should go away.

[ravichoudhary]

Thankyou sir,

My problem has been resolved by moving cross tab to summary band.