I have a requirement to generate a employees perforamnce report using ireportdesigner. For example, i have an employees table and want to generate pie chart for defects(sev1,sev2,sev3) that he/she fixed in a quarter for each employee. something like below, Query1= select employeeId from employees; Query2 = select employeeId, count(sev1),count(sev2),count(sev3) from employeedetail where employeeid= {employeeid from query1} group by employeeid; for each employee { generate pie chart; } Finally my report should have : employee1 name and pie chart, employee2 name and pie chart,employee2 name and pie chart ....................... Any suggestions? Thanks, Rmjrao.