Filter Column

The Filter Column is a table and column combination from your report that can be used to separate the data into a subset for each value specified in the selection value list. For example, to create an alert report for certain cities you would select the column for City and put the name of the city in the selection value list.

The columns available in the drop down list are from the columns in your Crystal Report.

The image below is an example of a alert report that will be run for each of the rows in the list. If the city field in the report has the value of "Los Angeles" it will filter on that column and send the report to "brenda@ripplestone.com" and then will run again and filter for "New York" and if there are any records in the report it will send the report to "jeff@ripplestone.com".

When using the LIKE operator include the wildcards in the selection value.  For example, if you wanted any city starting with "Los" the Selection Value would be Los*.  If you wanted "Los" anywhere in the value it would be *Los* in the Selection Value.

When using the IN operator include the square brackets "[" and "]" to enclose the selection.  For example, if you wanted the following cities to be used (Denver, Boise, Los Angeles).  The Selection Value would be ["Denver","Boise","Los Angeles"].