When you added the PLSupplierAccounts.SupplierAccountsName group, did you make it the top group (under and page header or report header group)? Use the View > Report Explorer option to check as there are some hidden sections (eg SYSCurrencies) so it needs to be above these.

Hi Gary,
Thanks for the suggestion. I then made sure that the Supplier Name group was the top group which did give me the alpha sort I was seeking BUT now I have lost the report total. The text Report Total is visible and the field is on the template but when printed the field is blank. I do see a total for each supplier, although this is described as the Currency Total (as SYSCurrencies is the next group in the sequence but this is easy to fix especially as we only have GBP suppliers).
Thanks again for your help and hopefully a simple 'tweak' will resolve the report totalling issue?

Hi Tony
Try moving all the variables out of the PLProposedPayments.PLSupplierAccountID header and move it into PLSupplierAccounts.SupplierAccountsName header and do the same with the footers. Then move the SupplierAccountName footer to where the PLSupplierAccountID footer is using the arrows on the section and maybe suppress the PLSupplierAccountID Header and footers and try then. This seems to work for me.

Hi Gary,

Sorry but tried what you suggested and still no joy - got report/section totals but still sorted in SupplierID sequence.  I have attached screenshot of my layout.  I have suppressed printing of the PLProposedPayments.PLSupplerAccountID header and footer, as you suggested.

Thanks Again!

Hi Tony, If you remove the PLSupplierAccountID Section from the report, that will then put the sort in account name order.

Gary & David,
Thanks both for your help with this - no fully resolved and I've learnt a little more along the way.
Kind Regards... Tony

Hi
I have found this website with a load of really useful reports, you may find this one of particular interest:

www.rich-reports.co.uk/.../report-121

Hi there,

There are a few options, that may help you achieve what you need;

• Contact your current support provider, who may be able to deliver this as part of your support contract
• Review the Sage report of the month library, which you can access here: ask.sage.co.uk/.../std_adp.php
• Contact our Sage 200 report design team to see if the report can be designed as part of Sage 200 Services, details can be found here ask.sage.co.uk/.../std_adp.php

Regards