Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Summary problem

Status
Not open for further replies.

edwindow

Programmer
Jul 13, 2001
51
US
I am trying to do a compliance report that tells me how many people have entered less than 40 hours per week. But I have to calculate hours per period. So the grouping is,from the top, by employee, period, and hours. At the detail level I have hours for each day and I summarize the hours at the period level. Then I try to do a simple calculation that says if total summary hours are less then 40 for that period then 1. At that point I was going to summarize the total 1's at the period level but Crystal will allow no more summaries. I tried to do the whole running total but I still can't sum past the period level. Has anyone tried to do counts like this?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top