Chart With XML Source

[2006 IR Open Dicussion]

By: Lucho - rebprotizer

Chart With XML Source

2006-06-13 05:28

I have an XML datasource and i would like to cretae a pie chart.

I have 2 fields : city (String) and clients (Long)

example of the XML file :

 

<root>

<row>

<city>Houston</city>

<clients>12</clients>

</row>

<row>

<city>Boston</city>

<clients>23</clients>

</row>

<row>

<city>NY</city>

<clients>31</clients>

</row>

</root>

 

Key expression : $F{city}

Value expression : $F{clients}

Label expression : $F{city}+" : "+$F{clients}

 

When i compile with iReport i have no error. But when i'm using my java program in order to generate a PDF or Excel report, I have this error :

net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression :

Source text : $F{nbClients}

 

So, I have tried to replace the value expression by : Long.getLong($F{clients})

and the type of the field clients by String

 

I have no error but no data...

 

The same report is working with a DBMS and CSV datasource.

 

Can you help me please ?

 

Thank you for your help.

 

Luc LABBE