Sorting multiple on the group
I need a report that generates customer details with the Contract Start Date and Contract End Date.
We need to have the report output with 1 entry for each customer. What I mean is there are many customers with double entry, this has to show as 1 entry. So for that I have grouped the customer name which removes the double entry. Also there are other fields as well that are placed in the group so that there is 1 entry for each customer.
Now the query is...once the above is done, I need to sort them based on the following:
1st Field 1(A to Z)
2nd Fielw 2 (A to Z)
3rd Field 3 (newest to oldest)
I tried to sort them, but unfortunatly the customer name(Field 1) is sorted but the rest is not getting sorted.. Is there way to sort these fields as well?
Your immediate reponse shall be greatly apprecitated.
Thanks & Regards