Sorting In Grids

TIER® TIDBITSGrids – To Sort, or Not to Sort?Have you ever wanted to sort results in a grid, or turn off the grid sort functionality?   There are 3 options for the sorting of columns built right into the grid utility.  In TIER® Design mode, locate the grid that needs sorting.  Click Customize:Click the level of the grid in the left pane that displays the column to be sorted/not sorted.  Next, click on the column in the right pane.  Locate SortOrder in Object Inspector.Note the 3 options for sorting that column.  Options soAscending and soDescending will sort data accordingly.  The option soNone might be used in those cases where the SQL or stored procedure on the lookup is performing the sort, and additional grid sorting may interfere or not be desired.  (See accompanying pdf with screen shots)