I have 2 groups in my report, Group # 1 the employee_id and Group # 2 work_date ("for each week")
I am displaying the total hours worked by each employee. I also created 7 forumals Sunday through Saturday and each formula contains a logic as such:
If {Day of Week} = "Monday" then
worked_hours else 0
Etc. for Tuesday, Wednesday and so on.
However, my problem is that it only prints a group # 2 when there is data in that period. What I need is to show the dates in between that did not have data during that period as well.
For instance,
It prints
04/27/2008 Monday 12 hrs Tuesday 7 hrs, etc.
05/11/2008 Monday 7 hrs Tuesday 8 hrs. etc.
I need it to also print 05/04/2008 Monday etc....
Any ideas?