Using the Sage 200 Report Designer you can choose to sort the data on your reports, into a particular order. For example, you may create a report that shows a list of Sales Orders and want the list to be sorted by Sales Order Date.

Adding a sort to a report, allows you to put the data into an order that is logical for the reports intentions, therefore making it easier for you to analyse.

When a sort is applied it affects the display of data within each section.

NB. It does not affect the order of the sections/groups, just the data within.

The example below is based on the Sales Order, Returns, Pro Formas and Quotations Report (Summary). This is grouped by Customer, and then lists the orders for each customer. The sort we are going to apply will change the order in which the Sales Orders are displayed, for each customer.

Talking Sage 200 – Sorting a Report

Advertisements