Contents
Strategic Partner Links
Sepasoft - MES Modules
Cirrus Link - MQTT Modules
Resources
Knowledge Base Articles
Inductive University
Forum
IA Support
SDK Documentation
SDK Examples
In addition to configuring rows, you can also configure how you want your data to appear in a report using the Sort and Filter functions in the Table component.
Sorting orders your data by a single data key or list of data keys. There are three types of Sorting in Tables.
Basic and TopN sorts can be configured for either ascending ( ) or descending ( ) sorts. They can also utilize aggregate (calculation) keys.
The TopN sort option, Include Others if selected, will include all values outside of the specified Count range by compressing them into a single row.
The CSV dataset containing all the data and the table used for the following Sort and Filter examples are shown below.
Dataset | Table in the Design Panel |
---|---|
The data for the Default sort is retrieved directly as-is from the dataset. No sort order is applied.
Configure Table | Default Sort Results |
---|---|
This table was sorted by the Order Number data key in ascending order. To sort in decending order, right click on the Order Number and select Sort Descending.
Configure Table | Basic Sort Results |
---|---|
This table was sorted by the Subtotal data key in ascending order with a Count value of 10 rows. To sort in decending order, click the Ascending icon
next to the Data Key to switch to Sort Descending.Configure Table | TopN Sort Results |
---|---|
Filtering gives the option of processing data based on an expression. The Filter Key property can be found in the Property Inspector under the Properties tab.
Notes
This example is sorted in ascending order using the Subtotal data key, and filtered for any 'Subtotal>1000.' To alternate to descending order, click the Ascending icon ( ) to toggle to a descending sort.
Configure Table & Property Tab | Filtering Results |
---|---|