I'm trying to produce a report (grouped by Employee) that will show every day in a month as a row value, whether or not there is matching Overtime detail for the date (and of course where there is matcing detail show it). The report would look something like this:
John Smith
Date Hours
01/01/2007 1
01/02/2007
01/03/2007
01/04/2007 3
01/05/2007 1
01/06/2007
etc.
I've tried using a separate Dates table and doing a Left Outer Join, so I get all the Dates, but it doesn't seem to work. I've read that it can have something to do with conditions in a Select on the Right hand table, but I still dont get a row for every date.
Is there an easy way to do this that I'm not finding? I've got books and checked online, but haven't found it yet. I hope I'll be embarrased at how easy the answer turns out being!
John Smith
Date Hours
01/01/2007 1
01/02/2007
01/03/2007
01/04/2007 3
01/05/2007 1
01/06/2007
etc.
I've tried using a separate Dates table and doing a Left Outer Join, so I get all the Dates, but it doesn't seem to work. I've read that it can have something to do with conditions in a Select on the Right hand table, but I still dont get a row for every date.
Is there an easy way to do this that I'm not finding? I've got books and checked online, but haven't found it yet. I hope I'll be embarrased at how easy the answer turns out being!