thanks for that, I tried it but it didn't work, me report works like this
I choose an employee .......
I then display all the customer orders done by that employee.
Each customer order is made up of customer order lines ....... the line total for each line is used to calculate the order total...