The report area definition defines a rectangular area on the input or report template workbook. It is shown when the template is opened (and printed) in the input or reporting function.

There can be multiple report areas on a sheet. Name the areas differently (for example, AREA1, AREA2). Each area must contain at least two rows (header row + 1 data row).

ACCCODE, row sets and TRANSLATIONS definitions are defined only once on the sheet.

At the top level, the Report, Multiple Areas example (EX_RT108) has the same content as the Simple Report example (EX_RT101). Beneath the top level, there is another report area with similar content, and the only difference is that the latter area shows figures for one month earlier.

Figure 66: Report, Multiple Areas

The following figures depict the area names and the workbook sheet.

Figure 67: Area names

Figure 68: Workbook sheet

In the XML file two very similar areas are defined, but their names, ids, and the month set for datacolumn1 and datacolumn2 of both areas are different.

Figure 69: Area definitions in the XML file

If a template contains several areas with generated columns, formulas between areas in the workbook must refer backwards from a latter area to a previous one.

Note! If there are several areas on the sheet, they must include the same number of columns (total of definition columns and data columns). Otherwise row sets do not work for the areas.