I've got a report - group 1 is CustomerData.AccountNum and group 2 is ARStatement.AccountName so currently, the report is sorted by the account number. I need to sort it by the account name. I've got some duplicate customer names in the ARStatement.AccountName field and if I simply group by the account name, these customer's get grouped together. I need them to show as individual customers but need them to be sorted by account name. Changing all the account names to unique values and then setting group 1 to ARStatement.AccountName isn't a viable option.
Hope this makes sense. It did in my head but that's not saying much ;).
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.