Through Data option in Actions menu, you can perform these functions:
-
Sort
-
Aggregate
-
Refresh
Sort
-
Select Sort to open a dialog where you can define a sort order for the grid.
-
Select the column you want to use first for sorting the data.
-
Define Ascending or Descending in the Direction box.
-
In the Nulls box, you can define whether empty values should appear first or last in the list.
-
Click + to repeat these steps if you want to use further columns for sorting.
-
To change the order of the columns used for sorting click or .
-
Click Save to activate the new sort order.
Aggregate
Aggregates are mathematical computations performed against a column. Aggregates display after each control break and at the end of the report within the column they are define.
-
Select Aggregate to open a dialog where you can define an aggregation for the grid.
-
Select the column you want to use first for aggregating the data.
-
Define the Aggregation.
-
Optionally, specify a Tooltip.
-
Click + to repeat these steps if you want to use further columns for aggregating.
-
Click Save to apply the aggregation.