Given my feelings towards subreports here is what I would offer as alternative. You can fine tune this as needed.
Create two command ojects in the database expert
1. Employees (Command Object) - here might be the SQL statement for that object.
SELECT employee.employeename, employee.employeeid, clockhours.dateworked,clockhours.hoursworked
FROM employee
LEFT INNERJOIN clockhours ON employee.employeeid = clockhours.employeeid
2. HoursWorked (Command Object) - Here might be the SQL Statement for that object
SELECT Hoursworked.employeeid, Hoursworked.timeworked,HoursWorked.DateWorked
FROM HOursworked
GROUP BY employeeid,dataworked
Then use the linking tab in the database expert to link the two command objects, Left Join the Employees object to the HoursWorked object. Make sure you Left join all the records the records from the Employee side to the those in the hours worked. Join by the Employee Id and dateworked
Then layout your report this way
GroupHeader 1a {employee.Name}
GroupHeader1b {ClockHours.DateWorked} suppress
` Details {ClockHours.HoursWorked} {HoursWorked.TimeWorked}
That should do it, all without a subreport, and their inherent difficulties.
I cannot test this for you, so there could errors, but hopefully its close enough to sort it out. Also you could build a second copy of the report and test this against it without losing the work you have done this far. I think you will know in about 10 minutes if this a viable solution.
Others on the forum can certainly chime with correction to the logic I am offering.
Hope this helps,
Regards,
John W.
www.CustomReportWriters.net