EXFO FastReporter 2 - Manual (Page 306)

Generating, Previewing and Printing Reports
296 FastReporter 2
Using Excel Report Templates
The sheet details are used to specify if multiple sheets should be inserted.
This table is not mandatory and is hidden by default.
Once the SheetDetails table is displayed, you need to specify the fields
below to insert multiple sheets:

SheetName: to specify the name of the sheet for which multiple sheets
are inserted. If you rename a sheet, you must also change it in the
sheet details to make sure that you generate multiple sheets in the
report.

AddMultipleSheets: to specify if multiple sheets should be inserted.

Tables (optional): to specify which tables are used in a particular sheet.

PrimaryTable: to specify the table from which you have to use distinct
values and add multiple sheets for each value.

PrimaryColumn: to specify the column name from the Primary table. A
new sheet is inserted for each distinct value of the PrimaryColumn.
Filter details are used to specify filter criteria. This is not mandatory, and
should be used when filters are required. Filter details are not hard coded.
You can specify the required filters; to do so the FilterDetails table must be
present in the report template.
FillMatchedOLM
Measurements
InSingleRow
To display the details from two different iOLM files
with different directions in a single row. (Used in
iOLM cable summary reports.)
FALSE
MergeAllSheets
InSingleSheet
To merge all sheets into first sheet. FALSE
MergeSheets
ByIdentifier
To merge sheets with the same identifiers. (This info
needs to be confirmed)
FALSE
Setting Purpose
Default
Value