Display Row Rank in a Table Control

You can use a formula to display a table row rank in a table control.

Step 1:  In the Layout Editor, select a table control and navigate to the table rows section.

Step 2:  Drag a literal control from the Toolbox into an empty cell within the ‘Table row’ area (the repeating row area).

Step 3:  Select the newly added literal control, and in the Property Sheet, select the ‘Initialize display text’ event.

Step 4:  Enter a formula to display the rank:

= OrdersTableControlRow.RANK(“Freight”)

Step 5:  Build and run your application.

Note: The column value used for the rank should be a numeric value.

See Also

Common Formula Examples