Hi
This is my very first post in CR forums I will try to explain what I need.
I want to make a report that displays for any given salesman the clients and their rent,
Salesman 01
Pedro | Jan | 30u20AC
What I did is having this result:
001
Pedro | Jan | 30u20AC
I want to replace the code of the salesman by the name of the salesman knowing that the salesman is in the same table as the client because the salesman is also a client but in a diferent level.
I wanted to put something like this in the report but I don't know how or where.
SELECT Name FROM Client WHERE Client.id = Contract.salesman
Can anybody help me?