report design

[Danny]

Greetings,

I have designed a Workers Productivity report based on a crosstab query to track how many applications the workers processed within 10 business days(<=10) and how many over 10 business days (>10) for the Fiscal Year.
1. How do I get a total for each Workers each Month? For example, if Alisa processed 4
applications within (<= 10) days and & 5 applications over(>10)days,
how do I get the report to show Total for Aldridge = 9.
2. How do I get to show both <= 10 and > 10 for each CaseWorkers, even if there is no data for them?

Attached is the sample report in word RTF format.

Thanks,
DD

 

[Danny]

Sorry that i wasn't able to get the attachement. Let's try again!

Thanks,
DD