Is it possible to create subreport in loop using ireport designer?

[rmjrao]

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.

[rlfisherpbtgroup.com]

You will want a main report using query1 to create your loop.  Put a subreport (query2) in the detail band of the main report.  You will need to pass some parameters (like employee id) from the main to the subreport.  You do not need to pass anything back if you are not aggregating the results from the individual employees.

[rmjrao]

Thank you verymuch for quick reply. how can i pass the parameter from main report to subreport?

[rmjrao]

Thank you verymuch rlfisher. After googling i am able to pass the parameter from main report to subreport also. Now i am able to generate a report what i want. Once again thank you.

[rlfisherpbtgroup.com]

Great, I am glad it worked out for you.