There can be multiple sheets on a template. Name the sheets differently (for example, Sheet1, Sheet2).

The ACCCODE, row sets, and TRANSLATIONS definitions as well as print areas and print titles are defined separately on each sheet.

The ACCCODE and TRANSLATIONS definitions must be named according to the following pattern:

•For the first sheet, give the name "ACCCODE1", for the second "ACCCODE2", for the third "ACCCODE3", and so on.

•For the first sheet, give the name "TRANSLATIONS1", for the second "TRANSLATIONS2", for the third "TRANSLATIONS3", and so on.

You can give the row sets the same names on several sheets.

The Report, Multiple Sheets example (EX_RT109) has two sheets. The Summary sheet is similar to the one defined in the Simple Report example (EX_RT101), and the Details sheet sis similar to the on defined in the Static Row Generation example (EX_RT103).

Figure 70: Summary sheet in Report, Multiple Sheets

Figure 71: Details sheet in Report, Multiple Sheets

The named cells are defined as follows:

Figure 72: Named cells

In the XML file two sheets are defined, and both of them have one area.

Figure 73: Two sheets each having one area