Specifying Excel output properties

You must specify various Excel output properties in the report.

  1. For the report as a whole, specify the Sheet Name property.
    See Changing report properties.
  2. For the layouts in the report, specify the Rows property.
    For Before Field layouts, you must also specify the Sheet Break property, and optionally, the Sheet Name Expression property.

    See Changing layout properties.

  3. For fields, images, labels, and barcodes, specify the Excel Output Column and Excel Output Row properties.
    Note: When printing to an EXCELRD device, only fields, images, labels, and barcodes for which these properties are filled are included in the Excel workbook. A property is ‘filled’ if the property is not blank and not equal to zero.
    See these sections:
    If you select multiple items, you can simultaneously specify property values for the selected items:
    • If you specify a column, the specified value is applied to the first selected item, and is incremented for the other selected items. For example, you have selected four items and you specify B in the Column property. For the first selected item, the value of the Column property is B. For the other three items, the value of the Column property is C, D, and E respectively.
    • If you specify a row number, that number is applied to all selected items, so that these items have the same row number.