Ordering of Details in Report

[33216CLC]

I am having a little difficulty in ordering a report by Employee Name rather than Id Number. I already have many reports that are odered by Employee Name, but one seems to be different. I use Crystal reports 7 as my reporting engine, VB6 for programming, and Access 2000 (97 format) as database engine. I attempted to order the table with this information using code in my program, but nothing happened.

Any ideas?

Thanks