Requisites

Set up requisites for electronic reporting.

Tables

Set up table requisites for electronic reporting.

Select

Change the area for the requisite, table, or cell.

Note
You can select the required cell range from the Microsoft Office Excel sheet and click Selectto update the selected area in the upper pane.

Go to

Go to the specified cell area in the Microsoft Office Excel sheet.

Names

Insert requisite names into the template.

Up

Move the selected line one position up.

Down

Move the selected line one position down.

Add

Add the selected cells to the requisite.

Requisites

Create requisites in the specified section.

Note
This button is available on the Tablestab.

Section

Select the document section that the requisites refer to.

Requisite type

Select the section requisite type from the following options:

• Cell– A requisite with the value selected from a cell in the Office Excel report.

• Constant– A fixed requisite set up in the Fixed Requisitesform.

• Value– A requisite with a value that is selected manually when the template is set up. This type of requisite value description may use macro replacements in the Valuefield.

Requisite

Enter the requisite code.

Attribute

View or modify the XML attribute name.

Description

Enter a description for the requisite.

Value

Enter the requisite vale.

Note
This field is available for editing only if Valueis selected in the Requisite typefield.

Worksheet

Enter the name of the Microsoft Office Excel worksheet.

Dynamic section

Select this check box to set up a requisite that is a property of a dynamic section.

Note
This type of requisite is a service object and will not appear in the report file. You can select this check box only if the requisite type is Cell.

Reference to value

Select the parent section requisite.

Note
The value in the Reference to valuefield must be the same as the value in the specified cell range. You can select this value only if the Dynamic sectioncheck box is selected.

Data type

Select the requisite data type from the following options:

• General– An undefined type of data with any kind of requisite value.

• Numeric– The requisite must have a numeric value, which is verified when importing the data. If a cell contains text, the imported value of the requisite will be empty.

• Text– The requisite may have any value.

• Date– The requisite must be in date format. If a cell contains any other type of value, the value of the requisite will be empty.

• Conditional– The value of this type of requisite will depend on the value shown in the cells when it is imported. If the cell is not empty, the value is taken from the Valuefield in the right section of the Requisites setupform. Otherwise, the value is taken from the Defaultfield.

Output type

Select the requisite output type form the following options:

• Optional– The requisite will not appear in the report file unless a value is entered.

• Required– The requisite is required and must always appear in the report file and cannot be blank.

• Predefined– The requisite must always have a code specified in the report file, although it might not have a value.

Default

Enter the default requisite value.

Note
The default value is required for requisites with a Requiredoutput type. The default value is used only if the imported requisite value created, based on the setting of the cell in the right section of the form, is empty.

Extended data type

Select the extended data type to verify the value of the requisite imported and save the settings.

Cell

View or modify the cell number.

Prefix

Enter the value to be added before the requisite.

Postfix

Enter the value to be added after the requisite.

Value

Enter the conditional requisite value.

Dynamic table

Select this check box to specify that the table is a dynamic table.

Area

View or modify the data area of the table that you are setting up.

Note line

Enter a note for the requisite.

Format

View or modify the format code for the requisite code.

Note
This field is available only for document templates earlier than Version 3.

Description format

Enter the description format for the requisite code.

Note
The value in this field can contain any values plus "%1" characters that are replaced with values from the Columnfield with Descriptioncolumn type when generating a report. This field is available only for document templates earlier than Version 4.

Table number

Enter the table number for the requisite code.

Note
This field is available only for document templates earlier than Version 4.

Name

Enter the requisite table name.

Column type

Select the column type for the table requisite:

• Line code

• Description

• Value

Column

Enter t he cell name of the first column of the Microsoft Office Excel document that will be used to create the requisite codes.

Column number

Enter the column number for the requisite code.

Note
This field is available only for document templates earlier than Version 4.

Line number

Enter the line number for the requisite code.

Note
This field is available only for document templates earlier than Version 4.