rapthor Posted November 12, 2009 Share Posted November 12, 2009 Hello community,I experimented with groups and representing them in a pie chart running into a problem:I added a group named "AGED_ABOVE_18" defined by a boolean expression like $F{AGE}>18. I was adding a pie chart that should display 2 slices, containing the number of group elements of each group (there will be only 2 groups depending on whether the group expression is true or false). In the end I want the pie chart to show me a slice of people aged > 18 and a slice showing people aged <= 18.Now I am getting confused what I would have to insert into the 3 editors in the Details tab of the pie chart.Key expression (???)Value expression (The number of records matching either true or false. - $V{AGED_ABOVE_18_COUNT} ???)Label expression (The number of records matching either true or false. - $V{AGED_ABOVE_18_COUNT} ???)Furthermore which Reset Type (Group - AGED_ABOVE_18 ???) and Increment Type (None ???) is correct? Thank you in advance! Post Edited by rapthor at 11/12/2009 12:59 Link to comment Share on other sites More sharing options...
kchaudhry Posted November 12, 2009 Share Posted November 12, 2009 I would just create a subdataset and use that for the pie chart. Your subdataset will return only two columns for example1. Age2 Count_Simply place the chart in the summary band and set the key exression to $F{Age} and value expression to ${Count_}Hope this helps! Link to comment Share on other sites More sharing options...
rapthor Posted November 12, 2009 Author Share Posted November 12, 2009 Hi,no that does not really help because the main dataset already takes quite long to be processed. Another database call just for the sub dataset would take similarily long.Is there a possibility to work on the same data set and still create this pie chart by processing the resulting records? Link to comment Share on other sites More sharing options...
kchaudhry Posted November 12, 2009 Share Posted November 12, 2009 Unfortunately, I'm only familiar with the subdataset approach. Maybe someone else can help you. 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