please help with hour calculations

[ericb123]

Using CR11 and SQL Server, I have a table of claim numbers, userID's, date, and hours worked per day.

So, for example, my data looks like this:

DATE USER CLAIM# HOURS
11/11/2008 joe 12345 8.5
11/11/2008 joe 54321 8.5
11/11/2008 joe 09987 8.5
11/11/2008 joe 65432 8.5
11/12/2008 joe 23445 7.5
11/12/2008 joe 87656 7.5
11/12/2008 joe 65432 7.5
11/12/2008 joe 09087 7.5

My report is grouped by userID, then by Date for each week. So I'm trying to find the number of hours worked per day and per week. For the week it would be 16 hours (8.5 + 7.5), how can I calculate this?

I tried using a SUM, but it's adding all the 8.5's for the same day. Any help is greatly appreciated, thanks!

 

[GJParker]

Use a running total

Field to summarize = Hours
Wvaluate = 'On chaneg of field' -> Date
Reset = On change of Group -> User

Place this in the User Group Footer

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[ericb123]

thanks! That works great. Is there a way to get this out of the footer and in the header? All the other fields are in the header, and when I move it there, it changes to an incorrect number.

Thanks!

 

[ericb123]

nevermind, I figured it out. Thanks again!

 

[lbass]

Please explain what you did, since you could not use a running total in the header and get the correct result.

-LB