pie chart

0

hi, i am using IReport version 5.6.0 , i want to visualise a pie chart divided by the nature of one field called "type"  so as i understood the key expression must be $F{type}, as for the value expression i want it to be the number of ligns in my database grouped by types, so i wrote the following query " select count(*) as orders, type from vacation GROUP BY type " , then putted $F{orders} as the value expression, but it's not working.

Any help? :(

 

 

fleur's picture
5
Joined: Apr 11 2017 - 9:08am
Last seen: 3 days 39 min ago

0 Answers:

No answers yet
Feedback