weird problem...

[jhermiz2]

I have a report showing labor during the week.
It just takes the daily days in hours and shows the totals for each department. I have noticed one problem with two employees (father and son) both the same last name.

The report does not seperate these two individuals, but it does seperate people who have the same name but different departments. Could this be why? Is it because they have the same last name and the same department?

Because the group by in the report is this:

DEPARTMENT
LABORCODE
LNAME

I did not create this report, a contractor did. I have to fix it though. I think this is where the problem lies, but love to hear reassurance. Can I add another group by for the EMPLOYEEID without affecting anything?

Thanks,
Jon

 

[bdreed35]

You could do several things here.

1. Create a formula that concatenates LNAME, FNAME and MNAME like this:

{table.LNAME} + ", " + {table.FNAME} + " " + {table.MNAME}

and then change your last group to group on this fomrmula instead of lastname.

2. You could also create a fourth group on EMPLOYEEID and then suppress the Group 4 Header and Footer.

~Brian

 

[jhermiz2]

I got it , that was the problem

Thanks,
jon

 

[IdoMillet]

No need for Group level 4. Just group at level 3 on Emp_ID and in the group dialog, select the "Customize Group Name Field" checkbox. Under that option, select the radio button to "Use a formula as a Group Name" and enter a formula such as:
{table.FNAME} + " " + {table.LNAME}

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com