By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

Reporting: Showing Number completed and % against Org Total

P: 10
I need a report which will show how many tasks have been completed for each employee and a percent of that based on the total tasks possible.

Example:
Tasks Total Pct
compl tasks Completed
Joe 5 20 25%
Mark 10 20 50%
Steve 5 20 25%

I'm drawing a blank on how to get the 20 for each person.
Dec 24 '07 #1
Share this Question
Share on Google+
4 Replies


puppydogbuddy
Expert 100+
P: 1,923
I need a report which will show how many tasks have been completed for each employee and a percent of that based on the total tasks possible.

Example:
Tasks Total Pct
compl tasks Completed
Joe 5 20 25%
Mark 10 20 50%
Steve 5 20 25%

I'm drawing a blank on how to get the 20 for each person.
In your report, you should be grouping by employee, then task. If that is the case, then in your Task group footer, you should have a textbox with its control source set to = Count(*).
Dec 25 '07 #2

P: 10
In your report, you should be grouping by employee, then task. If that is the case, then in your Task group footer, you should have a textbox with its control source set to = Count(*).
I understand the footings, but is there anyway I can get the overall total to print at the employee level?
Dec 26 '07 #3

jaxjagfan
Expert 100+
P: 254
I understand the footings, but is there anyway I can get the overall total to print at the employee level?
Have you tried using DCount or DSum to get the overall total?

or

Make a query which gives you the overall total you want. It should only return one value or column (overall total). Include this query with the original query/table for the report. You do not need a linking field or column since you want this value included for every column. Do not sum it in the footings or it will exaggerate your totals.
Dec 26 '07 #4

puppydogbuddy
Expert 100+
P: 1,923
I understand the footings, but is there anyway I can get the overall total to print at the employee level?
At the employee level, try placing the following expression in the control source of a textbox: = Sum(Count(*)), where Count(*) is the indivdual task count that was mentioned above.

Alternatively, you could use the DCount function as the expression in the control source of your textbox. Domain aggregate functions like DCount can be used to accmulate totals at whatever level you want.

=DCount("[Tasks]", "YourQuery", "[Employee] = '" & Report!Employee & "'")

=DCount("[Tasks]", "YourQuery") 'for overall task count
Dec 26 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.