Skip to Content
0
Former Member
Dec 08, 2008 at 07:55 PM

Displaying every week including where there is no data

44 Views

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?