If you are sorting just on one field set for this field \"Field Order\" to 1
\"Field Order\" allows to sort on multiple fields.
For example if you want to sort by Product name first than by Sales Amount
Tick sort for Product Name and Sales Amount fields
Than set \"Field Order\" to 1 for Product Name and \"Field Order\" to 2 for Sales Amount
Please let us know the outcome,
Mike