Sub-grouping in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to group employee hours by workweek (Sunday - Saturday) within
individual timesheets for a pay period based on dates.
So, the most recent pay period was 10/25 - 11/09, which starts on a Thrusday
and ends on a Thursday.
The weekday is indicated on the report via an expression. How can I group
the workweek within the calander worksheet?
 
dptroutt said:
I need to group employee hours by workweek (Sunday - Saturday) within
individual timesheets for a pay period based on dates.
So, the most recent pay period was 10/25 - 11/09, which starts on a Thrusday
and ends on a Thursday.
The weekday is indicated on the report via an expression. How can I group
the workweek within the calander worksheet?
Click to expand...


Try grouping on the start of week date using an expression
like:
DateAdd("d", 1-Weekday(dt,5), dt)
where dt represents your date field.
 
Back
Top