If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreport Links
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? -- Thanks, Jan |
#2
|
|||
|
|||
Subreport Links
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, -- Jan "Jan" wrote: 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? -- Thanks, Jan |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Subreport doesn't filter by links | New to the game | Setting Up & Running Reports | 0 | September 26th, 2005 11:06 PM |
Repost-Still Suffering with Subreports | IreneJ | Setting Up & Running Reports | 9 | August 31st, 2004 04:55 AM |
Still having Web Page Pathing Problems / Relative Links show Netwo | webmaster | Powerpoint | 27 | July 15th, 2004 11:16 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |