Exception as filling report

[diren_006]

Hi

 

It's urgent and kindaly difficult explain clearly about the jasper design.

But could anyone help to tell me what the possible reason cause the below exception.

 

 

java.lang.NullPointerException

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.getUserMeasureValues(BucketingService.java:467)

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.retrieveTotals(BucketingService.java:1222)

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.fillCell(BucketingService.java:1167)

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.fillCells(BucketingService.java:1129)at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.fillCells(BucketingService.java:1136)

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.createCrosstab(BucketingService.java:950)

at net.sf.jasperreports.crosstabs.fill.calculation.BucketingService.processData(BucketingService.java:383)

at net.sf.jasperreports.engine.fill.JRFillCrosstab.evaluate(JRFillCrosstab.java:389)

at net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:277)

at net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:399)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillColumnBand(JRVerticalFiller.java:1289)

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

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:228)

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

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

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

at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:498)

at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)

at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:137)

at java.lang.Thread.run(Thread.java:534)

 

Thank you~

[rsilverns.sympatico.ca]

Is it possible to post your report?

 

Thx,

Robin

[diren_006]

Hi Robin:

 

Thanks for help.

 

I've attached the jrxml.

 

One file with name RDSSalesModelDailyReport_SC_RDS_Location.jrxml is the main report, and two subreport are locationDaily.jrxml and locationMtd.jrxml.

 

Thank you!

[diren_006]

Sorry,

Here is the attachment [file name=location.zip size=6440]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/location.zip[/file]

[diren_006]

Hi man:

 

I've found the cause of the problem.

 

The cause is I check the "data is presorted", but the actual dataset is random, I mean is in disorder.

 

Then I uncheck "data is presorted", it works well and the outcome is exactly what I want.

 

Thank you!