fleur Posted April 20, 2017 Share Posted April 20, 2017 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? :( Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now