During an AddPage operation, filter the data as it is being loaded. Multiple filter criteria may be specified and data rows must pass all critreria to be loaded into memory.

Syntax:

FilterGlobally, columnType, columnId, operator, value

Parameters:

columnType – the type of column to be filtered { text, date, numeric} 

columnId – the column caption to be filtered

operator – the filter operator to be used; for text columns {StartsWith, EndsWith, Contains, Exactmatch, NotStartsWith, NotEndsWith, NotContains, NotExactmatch  }; for date or numeric columns {Equal, NotEqual, LessThan, LessThanOrEqualTo, GreaterThan, GreaterThanOrEqualTo}

value - the value to be used in the comparison; text and numeric comparisons may have multiple, tilde-separated values

Examples:

FilterGlobally,date,local_date,lessthan,2008~01~01

Keep a row if the actual date in the column identified as “local_date” is Less Than 2008-01-01.

FilterGlobally,text,campaign,ExactMatch,2363~2377

Keep a row if the text in the column identified as “campaign” is "2363" or "2377" 

FilterGlobally,numeric,sales,LessThan,43000

Keep rows which have less that 43000 in the column labelled ‘sales’.

Comments: