perhapps you used the wrong outer join.
If you have a date table, you should be able to outer join to it and get all the values. Of course you could use a stored proc, but that might entail rewriting the report.
In SQL it would look like:
select * from employeeDate AS ed right join AllDates AS ad on ad.date = ed.Date
I don't like right joins, but if you have already written the report, a right join is the simplest concept.
HTH
IP Logged
