The sort for a report is set by the report...you can do it by changing the sort using Record Sort Expert or you can create a group which will allow you to sort on the field as well.
Suppression of the display is easy, just put logic to return TRUE in either the cell (format text/Common/x-2 across from Suppress, or the whole row using the Section Expert.
If you want conditional aggregates based on the displayed data(like SUM) you will need to create either running totals or to use shared/global variables to correctly perform these functions.
HTH
IP Logged
