multiple charts based on employees in report

I have two charts that are subreports. I want to see if I can do one of two things.

Give the user the ability once the report processes to change the employee name and refresh the chart. Format the subreports to repeat the charts for as many employees that are in the main report. Sometimes there will be 8 other times there will be as many as 20.

Yes. For 1, you can pass the employee name through report parameter and let the user to change the parameter value. For 2, you can put the subreports into a list, and set the grouping on the list to be the employee name.

|||Could you give me a little more detail on the solution for option 2?|||Int he example of a table you place your chart in the details pane. For every employee listed (detailed grouping) or if you want to do it on a grouping level for every grouping value, none chart will be displayed on the based data for the group / detailed row.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de