Report grouping / sorting help needed! 1

[cpjeffm]

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 .

 

[Charliy]

You can create a formula like {table.accountname} & {table.accountnumber} and group on the formula.

 

[cpjeffm]

Well I feel dumb lol. That was easy. Thanks!