I have a report that pulls from 2 tables with the following fields:
employeeid, lastname, firstname (table 1)
date, hoursworked (table 2)
I am trying to run a simple report that shows id, name and total hours for a given time period. in the report i need to group by employeeid, but want the report alphabetized by last name. i don't want to sort by the id number, as it is easier to look up a name if it is alpha. actually, the employeeid does not even have to print, but if i don't group by employee id, it sums different employees with the same last name.
any suggestions on how to remove the "sort" option in the sorting and grouping the report?
thanks.
employeeid, lastname, firstname (table 1)
date, hoursworked (table 2)
I am trying to run a simple report that shows id, name and total hours for a given time period. in the report i need to group by employeeid, but want the report alphabetized by last name. i don't want to sort by the id number, as it is easier to look up a name if it is alpha. actually, the employeeid does not even have to print, but if i don't group by employee id, it sums different employees with the same last name.
any suggestions on how to remove the "sort" option in the sorting and grouping the report?
thanks.