Setting the Spec Range

Sage 300 ERP

Home > Financial Reporter > Printing Financial Statements > Setting the Spec Range

Setting the Spec Range

The Spec range is a named range of spreadsheet cells that begins with the first row and column of the report specification, and includes all cells that are part of the specification.

Before you can generate a report from a report specification, you must define the Spec range for your spreadsheet.

To define the Spec range in a Financial Reporter spreadsheet:

  1. With the statement spreadsheet open in Excel, select the complete report specification, from the first row and column to the last row and column.
  2. On the Excel Ribbon, click Formulas > Define Name.
  3. Type Spec as the range name, then click OK.

    Important! You must type exactly these letters, although the capitalization doesn't matter.

Note: You do not define a Report range for the spreadsheet. Financial Reporter defines the Report range when it generates the report from a specification.