Filtering Data

A dataset bound to a report often contains far more data rows than it is required to process for report creation. In this case, the data must be filtered according to certain filter criteria which can be built upon a single or multiple data fields.

To filter a report's data, click its Smart Tag, and in the invoked actions list, click the ellipsis button for the Filter String entry. Then, in the invoked Filter String Editor, construct an expression.

You can use the built-in filtering capability provided by Advanced Reports. For this, it is necessary to set the required filter to a report's Filter String property. Click on the report's smart tag and select FilterString Editor. In the example below, we are selecting only those drillholes which were completed after January 1, 2013 and which have a depth greater than 100.

When creating a filter criteria, you can create and edit logical expressions and also join the expression groups, providing a structured tree-like view.

You can join the expression groups with the logical AND, Or, Not And, and Not Or operators. The editor also provides an extensive list of logical operators, as illustrated below:

You can also choose the text tab and enter your filter directly.

In every filter condition, the left part contains either the data field name, or the name of the calculated field which exists in this dataset at the same level. The right part of the condition contains either a certain numerical or string value, or the name of the report parameters.

To quit the Filter String Editor dialogue and save the changes, click OK.