In addition to the main report filters that allow you control stores and supplier and so forth most reports come with field level sort and filter built in. This allows you to sort data by the value of the report field and to limit the contents of the report. Such as prices > 100 sort by gross profit and so forth.
Using the Sort
- Just click on the report field name and the up and down arrows will show the ascending and descending sort.A thrid click sets the data back to it's default order.
Using the Filters
- Click the little funnel icon to the right of the report field name.
The field filter dialogue allows you create and/or combinations of conditions to limit the data in your report.
- Click Filter when your done and your report results will be refreshed.
- To cancel a filter use the clear button.