i have in report's DE two tables, balance and employee. balance has empno field but i want to display firstname and lastname of employee, so i set relation from balance to employee table. this works perfectly fine.

but i want to set the order accordning to employee.lastname? how do i do that? i have in my DE, balance as initialselected.

any help pls?