We are seeing an issue where we want to change the sort on the Precheck Report by Lastname, FirstName, then MiddleName. It seems like the sort will work but the issue seems to be when it runs into a duplicate LastName (goes to the secondary sort method). It triggers the report footer to print and then it continues on with the rest of the employees. So the Report totals aren't at the bottom of the report but where the first duplicate lastname is.
Has any come across this issue before or any suggestions?
I just modified my report to sort like you mentioned. I went into report writer and put in a custom sort by Last Name, First Name, Middle Name. I then created several employees with the same last names, the same last and first names, some with and without a middle name. It behaved perfectly. If you still have a problem, I'll be happy to take a peek at your package file if you want to send it to me.
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * firstname.lastname@example.org
The only question I have about your report is whether you want the amounts listed by each customer to represent the receivable net of available discounts or just the base receivable?
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics