Help creating a pie chart format

[cmcilip]

Hello, I have browsed a few forums and am still having trouble creating a pie chart that has the proper layout that I would prefer.

I have created a query that will list the data I would like to organize into a pie chart. The query, when run, will prompt the user for a start date and an end date and then display the data in this form:

EmployeeX | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
EmployeeY | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)


OK, now that I have the data in this format I would like to create a report that includes tabs for each employee, each tab will have a pie chart that has one employee and a pie chart showing how their hours are allocated to each task. e.g. tab 1 would have Employee X and the pie chart would show what percentage of this employee's hours was dedicated to project/demo/admin/etc...

If anyone can help me set this up I would greatly appreciate it, currently when I am setting up a pie chart I have no idea how to specify that I only want the data to come from the field EmployeeX, on top of that I am not sure how to add more than one data series (i.e. the sum of projects and sum of demos etc...) Any help would be greatly appreciated! Thanks.

 

[Estuardo]

G'd evening,
I don't think you need tabs in a report... no one will be able to click on them.
What you can do is to run the same report for each one of your employees and try to export all the reports to same pdf file.
May be other members come out with a better approach.
G'd luck