Charts inside a Grouped List

Hi, 
I am fairly new to BIRT. I have a requirement of displaying charts inside the List. 
Can this be done? 
 
For exmaple, i have a data set which lists ID, City, Branch and another data set with ID, EmployeeType,<other employee details> 
 
Now what i have done is a List grouped by Branch+City (say, "London, Stamford Bridge") and then display details of each employee of that branch. Then the next branch and so on. 
 
Now what i need is to display a Pie chart which shows the Employee type division and count (say, 4 Supervisors, 12 Managers, 35 Developers ...) This should be displayed once per Branch. 
 
Can anyone please help me with this? 
I am using BIRT 3.7.1 as an Eclipse Plugin. 
 
[I have been finding answers in forums till date and dint have to register. Now i am in need of an answer i dint find in the forums] 
 
Thank you very much in advance

Find more posts tagged with

Comments

mwilliams

Can you show some sample data from your two dataSets?

Giria

I have attached two files. The ID acts like the key between the two. I need to compare the key and then achieve the result.

Thanks for your reply and help. Hope you can help me.

mwilliams

Take a look at this report. It uses your two files above, for sources. Just change the location in the dataSource to where you have the files saved and it should run.

Giria

Whoa! That was awesome

I was hung up on Lists, dint think about tables. Thanks a lot

I understood how you got that done, but when i tried it, it dint not work. :wacko: 
 
I created a table bound to the Join Data set, created the two groups and added the aggregation on 2nd group footer. 
Now when i add the chart in Group1 header, and inherit rows and columns, the Aggregation i added shows outside of the Grouping which i cannot use. 
 
How did you get it to appear inside the Grouping? <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif

mwilliams

Can you attach your design? If you cannot attach it in here, can you send it to me by email? mwilliams@actuate.com

Giria

Thanks

But i dunno what was going wrong, it worked when i tried it the next day!
It working fine now and i am learning more things.
Main thing i was missing was the join data set

Thanks a ton for your help!

mwilliams

Ah. Great! Glad you got it working! Let us know whenever you have questions!