Group Sorting Issue

[eric333]

I have developed a report that lists employees and summarizes some transactions for each employee. The report conists of two tables, the employees and the transactions. The tables are linked by the Employee ID and the transactions are all grouped by the employee ID. It's a long story, but the employees may have multiple records in the employee table, so it is necessary to first group by employee ID in order to generate the data.

I want to sort the report by employee name, not ID. However, since the report is grouped by Employee ID, I'm seemingly unable to sort the report by employee name.

Does anyone have any ideas?

 

[eric333]

And just to clarify, I have a Group Select statement that is a factor in this report. The Group Select statement is:

isnull({Card.EndingDate}) and
({Card.Deleted} = false) and
{Card.ID} = Maximum ({Card.ID},{Card.CardNumber}) and
({Card.LastName} > '1')

 

[eric333]

Please disregard my posting. Apparently I have not have enough chocolate today. I figured it out. Sorry everyone...