Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Details Repeating - Again
- Thread starter sprog
- Start date
The link is the issue, most likely. Are there many-to-one relationships involved here?
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #3
Please give some details on the fields of each table, how the tables are linked, and where the many-to-one relationship exists.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #5
I have 3 tables. 1 with employee information (ie; name address, start date etc), 1 with employee history (ie; pay period ended dates, types of payments (annual leave ordinary etc) and the other table is timesheet history, where I am pulling the GL code from.
(I only want details for one particular GL Code). I think it is this last table which is causing problems. "Timesheet History".
Timesheet History and Employee History are both linking to Employee with the link going to a field called "Employee Id".
My linking seems automatic and I am on version 9.
Thanks
(I only want details for one particular GL Code). I think it is this last table which is causing problems. "Timesheet History".
Timesheet History and Employee History are both linking to Employee with the link going to a field called "Employee Id".
My linking seems automatic and I am on version 9.
Thanks
OK, what info do you want on your report? Please give an example report results versus what you are getting now.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Thread starter
- #7
Sorry, for being a nuisance.
I want: Employee Name, Period Ended Date, Ord Hrs Worked, Dollar Value Paid Out.
I only want employees with wages being charged to one particular cost centre.
I need the employee table for the employee name. I need the employee history table for the period ended date, hours worked and paid. I need the timesheet history table to give me the cost centre these were charged to.
I am filtering by cost centre (ie; GL Code is equal to 4611396).
I want: Employee Name, Period Ended Date, Ord Hrs Worked, Dollar Value Paid Out.
I only want employees with wages being charged to one particular cost centre.
I need the employee table for the employee name. I need the employee history table for the period ended date, hours worked and paid. I need the timesheet history table to give me the cost centre these were charged to.
I am filtering by cost centre (ie; GL Code is equal to 4611396).
If you can't get the links sorted, you could always suppress the extra detail lines. That's what I do on a lot of my reports, cases where extra suppressed lines do no harm.
Specifically, for Crystal 8.5
a) Right-click and [Format Section].
b) Set up a Suppress formula
{Employee ID} = Previous ({Employee ID})
Madawc Williams
East Anglia, Great Britain
Specifically, for Crystal 8.5
a) Right-click and [Format Section].
b) Set up a Suppress formula
{Employee ID} = Previous ({Employee ID})
Madawc Williams
East Anglia, Great Britain
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question