iReport 1.2 : bar chart properties

[2006 IR Open Dicussion]

By: Lucho - rebprotizer

iReport 1.2 : bar chart properties

2006-03-20 02:02

Hello all,

 

i'm using iReport 1.2 in order to create a simple bar chart.

i've got this query :

select offi.city, count(*) as "NbCmdes"

from offices offi, employees emp, customers cus, orders ord

where offi.officecode=emp.officecode

and emp.employeenumber=cus.salesrepemployeenumber

and cus.customernumber=ord.customernumber

group by offi.city

 

After I add a bar chart. But i don't know what i have to put in chart properties for my data.

 

I would like a bar chart with the count of sales per city.

if i do that :

Series expression : $F{NbCmdes}

Category expression : $F{city}

Value expression : $F{NbCmdes}

 

I have this error in the compilation of the report :

Filling report...

Locale: français (France)

Error filling print...

java.lang.NullPointerException at net.sf.jasperreports.charts.fill.JRFillCategoryDataset.customIncrement(JRFillCategoryDataset.java:136) at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:134) 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.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:730) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:651) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:89) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:601) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:517) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:653) at java.lang.Thread.run(Unknown Source)

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

 

Thank you for your hopping help.

 

Luc LABBE