EXFO FastReporter 2 - Manual (Page 308)

Generating, Previewing and Printing Reports
298 FastReporter 2
Using Excel Report Templates
One sheet can have multiple filters.
The range indicates the address of the first cell and last cell for which you
want to apply the filter, separated by a colon. The range must exactly
match the range in the sheet; if you specify a filter range of $A$3:$C$3 and
the actual range in the FilterDetails table is $A$3:$F$3, the formula is not
applied because they are not considered as matching.
The filters are to specify conditions and support the AND and OR operators.
You need to provide TableName.FieldName as a field. For example,
OTDREventTable.IsEvent=true AND OTDREventTable.IsEventReflective
=true AND OTDREventTable.EventLossAtoBPassFailStatus='Fail'
An additional sheet is available, the Table sheet. The Table sheet is
generated by a macro when a template is saved. It contains information on
different tags present in the template and it will be used to generate the
appropriate data set (result values) needed for the report.