Subreport Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Help!
I have a main report - Employee Summary
I have a few subreports within the main - late, early, errors, and tc detail.
The first three report fine; however the tc detail does not.
My child/parent links are Employee ID but for some reason the tc detail
picks up more than one employee on the same page. (I failed to mention the
tc detail subreport is in the detail section of the main report and reported
in columns of 3.)

If there is no data for the third column, then it fills it with the next
employee id. How do I change it so ONLY THE EMPLOYEE information shows for
that employee?
 
Summary Report sql:
SELECT Employee.[Employee ID], Employee.[Employee LName], Employee.[Employee
FName], Employee.Department, Employee.Cat, Employee.InActive, Employee.[Use
Time Card], Employee.[Start Time], Employee.[End Time], Employee.[Schedule
Vary?], Employee.[Flex?], [Employee FName] & " " & [Employee LName] AS
Employee
FROM Employee
WHERE (((Employee.Cat)="Contract" Or (Employee.Cat)="Revenue") AND
((Employee.InActive)=No));

tc detail sql:
SELECT [Time Card Detail].[Wk Ending #], [Time Card Detail].Date,
Employee.Department, Employee.[Employee ID], Employee.[Employee FName] & " "
& Employee.[Employee LName] AS Name, [Earn Codes].[Earn Code Short], [Time
Card Detail].[In], [Time Card Detail].Out, [Time Card Detail].In2, [Time Card
Detail].Out2, [Time Card Detail].[Reason(if needed)], [Time Card Detail].[Dr
Note], [Time Card Detail].Other, [Time Card Detail].Paid, [Time Card
Detail].[Paid Late?], [Time Card Detail].[Early Check], Employee.InActive,
Employee.[Start Time], Employee.[End Time], Employee.[Schedule Vary?],
Employee.[Flex?], IIf([In]>8,"Yes","No") AS [Late Clock In?]
FROM [Earn Codes] INNER JOIN (Employee INNER JOIN [Time Card Detail] ON
Employee.[Employee ID] = [Time Card Detail].[Employee ID]) ON [Earn
Codes].[Earn Code ID] = [Time Card Detail].Code
WHERE ((([Time Card Detail].[Wk Ending #]) Between #6/19/2005# And
#9/30/2005#))
ORDER BY [Time Card Detail].[Wk Ending #], [Time Card Detail].Date,
Employee.Department, Employee.[Employee ID];

I hope these help. Thanks again,
 
Back
Top