Flows:

• Help—Access help on the report wizard.
• Cancel—Return to the REPORT—ReportWizard Form.
• Close—Close this form.
• Back—Load the next form of report template definitions.
• Next—Load the previous form of report template definitions.
• Finish—Close the form and save the report template to the selected file.

Form:

Step 1:

• File name—The URL of the report template file.

• Edit at end—Indicates whether to open the report template file in a script editor at the end of entering the steps into the report wizard.

Step 2:

• Type of report block—Set to Data block only.

• Header—Indicates whether a report header is included.

• Mode—Layout of the scheme-analytes versus the samples, either:

  • 0—Normal (non-inverted) analytical report, structured so the schemes and analytes flow down the page and samples flow across the page.
  • 1—Inverted analytical report, structured so the samples flow down the page and the schemes and analytes flow across the page. This is mainly used when reporting the analytical results for a small number of samples, but a large number of scheme/analyte combinations.

• Style—The style for the scheme-analytes verses the samples grid, displayed in the Style layout panel.

• Style layout—The layout associated with the selected Style.

Step 3:

• Where—A clause which evaluates to true or false used to determine the data that is included in the data block. The clause is written in VBScript, and can contain references to the clsBDProfJob, clsBDScheme, and clsBDClient classes.

• Break—New indicates whether each page is put on a new sheet in the spreadsheet, andSame indicates each page is placed on the same sheet of the spreadsheet as the previous page.

• Rows—The number of rows in the data block section.

• Columns—The number of columns in the data block section.

• Reset sequence—True indicates the use of the Seq tag to print the current record number within the group on the report, and False indicates that the current record number is not reset for each new sheet.

• Datablock full size—True indicates that if the sheet contains an incomplete number of samples or analytes (depending on whether a normal or inverted report mode) to fill down the data-block, then any data following the data-block (for example, report footer) is still placed after the data-block, and False indicates that any data following the data-block is placed after the last sample or analyte in the data-block.

• Datablock cell format—True indicates that if the sheet contains an incomplete number of analytes or samples (depending on whether a normal or inverted report mode is selected) to fill across the data-block, then any data to the right of the data-block is still placed after the right-hand side of the data-block, and False indicates that any data to the right of the data-block is placed immediately to the right of the last analyte or sample in the data-block.

Step 4:

• Sample—The table (PROFJOBCUID or PROFJOBCUIDUSER) and field from which to retrieve sample data.

• Analyte—The table (PROFJOBSCHEME, PROFJOBSCHEMEANALYTE, UNIT, SCHEME, SCHEMEANALYTE, PRODUCTANALYTE) and field from which to retrieve analyte data.

• Data—The field from which to retrieve analytical data.

• Data block—The structure of the data block for the sample row/column header, scheme-analyte column/row header, and sample-scheme-analyte intersection.

Step 5:

• Object—The datablock, special character or table available for adding to the report output.

• Fields—The fields associated with a special character or table Object.