Report Wizard - Filtering Tab

<< Click to Display Table of Contents >>

Navigation:  »No topics above this level«

Report Wizard - Filtering Tab

Previous pageReturn to chapter overviewNext page

 

The Filtering tab allows you to define a filter to restrict the amount of data that is included in the report.  Each row from the data source is tested against the filter expression.  If the filter returns true that row is included in the report, otherwise it is skipped.

 

Each row shown in the Filtering tab is a unique filter expression.  Each Filter expression consists of a field name, a comparison operator and a value.  Individual filter expressions can be combined to create complex compound filters.

 

_bm30

 

Click the _bm31 button to add a new blank filter expression. The first step to defining a filter expression is to select one of the data source fields.  When a cell in the field column is highlighted, a small button will appear in the upper right hand corner of the cell.  Clicking this button will display a list that contains all the fields in the data source.  To select a field, simply scroll down in the list and click the desired field.  

 

The next step is to select an expression comparison operator.  When a cell is selected in the expression comparison operation column, a button appears to allow you to select from the list of available operators.  The following operators are supported:

 

Operator Symbol

 Function

<

 Less than

<=

 Less than or equal to

<>

 Not equal

=

 For non-string fields (integers, logicals, dates), this operator means equal.  For string data types the operator means begins with.

= =

 For string data types this operator means exactly equal.

>

 Greater than

>=

 Greater than or equal to

 

After you have selected an expression comparison operator, you enter the value that you wish to compare the field against in the expression value column.

 

The Filter tab allows you to combine multiple filter expressions to create a larger, more complex compound filter.  When you add additional filter expressions, you must define how each new expression relates to the other expression(s) that you have already defined.  The first column in the Filter tab is where you specify the expression relationship operator that defines how each expression relates to the previous expression(s) in the list.

 

The Filter tab also allows you to group expressions together using parentheses.  Up to three levels of parentheses are supported.  To specify a parenthesis, select the desired open or close parenthesis column and click the small button that appears in the upper right hand corner of the cell.  When the button is clicked, a list of available options will be displayed.

 

It is important to note that the filter you define here is ReportPro's local filter.  Some data sources like the Jasmine database and ODBC data sources often support filtering at the database server level.  For performance reasons, you should in most cases, use the filtering mechanism available at the database server level.  When supported, the server filter is specified in the server specific configuration dialog.

 

 

Also See:

 

Report Wizards

Standard Report Wizard