ActiveReports 12 Server Designer User Guide
Adding Table Filters

You can add filters to limit the amount of data displayed in your table using the Filter adorner. You can also group them or make them interactive with parameters.

To add a table filter

  1. Click the table to reveal the table adorners, and click the expansion arrow to the right of the Filter adorner to expand the Filter workspace.
  2. Click the Add Criterion icon to add an attribute by which you can filter the data.
  3. Drop down the default attributes and double-click one one to add it to the list of filters.
  4. The default comparison operator is equal to. To select a different comparison operator, click the drop-down arrow to the right. A different set of comparison operators are available depending on the data type of the attribute.

    Available Comparison Operators

    Operator Name Description
    equal to Displays only data that is the same as the specified value.
    not equal to Displays only data that is not the same as the specified value.
    begins with Displays only data that begins with the specified letter.
    in list Displays only data that has a value in the specified list of values.
    greater than Displays only data that has a value higher than the specified value.
    greater than or equal to Displays only data that has a value higher than or the same as the specified value.
    less than Displays only data that has a value lower than the specified value.
    less than or equal to Displays only data that has a value lower than or the same as the specified value.
    from... to Displays only data that has a value that falls between the two specified values.
  5. To enter a value with which to compare data, type one in the (unspecified) text box, or drop down the list of values to the right and double-click to select one.
    Tip: Select (null) to find null values. For example, if you are looking for living people, you would want a "date of death" attribute to be (null). You can use (blank) to find values such as descriptions that were left blank.
  6. To allow the user to select values for the filter, select Prompt.

    See Making Interactive Table Filters and Working with Parameters for more information on this option.
See Also

Reference