ActiveReports 9 Server End User Guide
Adding Table Filters
Working with Tables > Table Filtering > 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

  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
Grouping Table Filters
Making Interactive Table Filters
Removing Table Filters
Working with Parameters

Reference

Table Filtering

 

 

Copyright © 2014 GrapeCity, inc. All rights reserved

Support Forum