JasperStudio 6.3.1 chart problem

[domagoj.hrzic]

Hi all,

having trouble generating a chart, I'm using JasperStudio 6.3.1.

I created query that joins multiple tables, for categorized reporting.

I have let's say 80000 rows with a priority defined for each row with 5 different priority values repeating.

Now I want to create a pie chart to display priority count for each value.

As chart dataset series i put column where are all of the priorities repeating, and in value count of all rows.

I'm getting the error:

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: Key 3 normal is duplicated in pie dataset.

Is there a way, parameter or function to avoid this problem. I'm aware that it would be better to write only query to get the set of 5 value with a total count.

 

Please help,

 

Thanks

 

[mgahenson]

Try setting the key equal to a primary key or a field that uniquely identifies each set of information. It seems that currently your field used as the key value contains duplicates.