Type Template Report
Excel Download template Download report
Excel Download template Download report
Word Download template Download report
Excel XML Download template Download report
Word XML Download template Download report
Adobe PDF Download template Download report
Generate this example Choose a template and create a fresh report with the demo service.

xtt->merge( iv_block_name = 'R' is_block =

JSON 
{"TITLE":"Title","T":[{"GROUP":"GRP A","CAPTION":"<Caption 1 />","DATE":"2020-10-21","SUM1":5971.44,"SUM2":5021.46},{"GROUP":"GRP C","CAPTION":"<Caption 2 />","DATE":"2020-10-19","SUM1":2276.75,"SUM2":7717.2},{"GROUP":"GRP B","CAPTION":"<Caption 3 />","DATE":"2020-10-20","SUM1":3031.38,"SUM2":445.22},{"GROUP":"GRP A","CAPTION":"<Caption 4 />","DATE":"2020-10-21","SUM1":9476.79,"SUM2":3683.27},{"GROUP":"GRP A","CAPTION":"<Caption 5 />","DATE":"2020-10-21","SUM1":4604.0,"SUM2":5525.85},{"GROUP":"GRP C","CAPTION":"<Caption 6 />","DATE":"2020-10-19","SUM1":2159.71,"SUM2":2260.94},{"GROUP":"GRP B","CAPTION":"<Caption 7 />","DATE":"2020-10-20","SUM1":2490.3,"SUM2":6388.81},{"GROUP":"GRP A","CAPTION":"<Caption 8 />","DATE":"2020-10-21","SUM1":5476.81,"SUM2":406.18},{"GROUP":"GRP D","CAPTION":"<Caption 9 />","DATE":"2020-10-18","SUM1":689.66,"SUM2":518.6},{"GROUP":"GRP C","CAPTION":"<Caption 10 />","DATE":"2020-10-19","SUM1":5451.87,"SUM2":4061.85},{"GROUP":"GRP D","CAPTION":"<Caption 11 />","DATE":"2020-10-18","SUM1":4573.55,"SUM2":5436.0},{"GROUP":"GRP C","CAPTION":"<Caption 12 />","DATE":"2020-10-19","SUM1":1196.35,"SUM2":522.46},{"GROUP":"GRP C","CAPTION":"<Caption 13 />","DATE":"2020-10-19","SUM1":7686.95,"SUM2":2727.98},{"GROUP":"GRP D","CAPTION":"<Caption 14 />","DATE":"2020-10-18","SUM1":978.18,"SUM2":295.55},{"GROUP":"GRP D","CAPTION":"<Caption 15 />","DATE":"2020-10-18","SUM1":71.12,"SUM2":8878.56}],"DATE":"2020-10-21","TIME":"12:12:12","DATETIME":"20201021121212"}

).
Generate demo 020

Basic table example

Request preview

Purpose

Demo ZCL_XTT_DEMO_020 shows the standard table workflow. A flat internal table is exposed as component T, repeated by the template, and rendered in XLSX, DOCX, Excel XML, Word XML, or PDF.

Define the report context

Declare the repeated data as an internal-table component of the root structure:

    " Document structure
    BEGIN OF ts_root,
      footer   TYPE string,
      header   TYPE string,
      t        TYPE tt_rand_data, " internal flat table ( In template {R-T} )
      date     TYPE d,            " 8
      time     TYPE t,            " 6
      datetime TYPE char14,       " date(8) + time(6)
    END OF ts_root.

TT_RAND_DATA is a standard table with the following row type:

      " Random table data
      BEGIN OF ts_rand_data,
        group   TYPE string,
        caption TYPE string,
        date    TYPE d,
        sum1    TYPE p LENGTH 13 DECIMALS 2,
        sum2    TYPE p LENGTH 13 DECIMALS 2,
      END OF ts_rand_data,
      tt_rand_data TYPE STANDARD TABLE OF ts_rand_data WITH DEFAULT KEY,

Define the repeated range

The template contains the root marker {R-T} and field markers for the row components:

The repeated pattern may span several physical rows. XTT treats the range from the first {R-T} marker to the last marker for that block as one logical record.

Populate and merge the data 

    " {R-T} in the template. See GET_RANDOM_TABLE.
    ls_root-t      = cl_main=>get_random_table( ).

    " Header and footer values
    ls_root-footer = 'Footer'.
    ls_root-header = 'Header'.

Result and Excel behavior

The resulting Word document contains one copy of the repeated range per table row:

In XLSX output, Excel tables and their formulas are expanded to cover the generated rows.

Use Ctrl+F3 in Excel to inspect workbook names.

image

Data-validation ranges are expanded automatically as well. image

XTT preserves worksheet-scoped and workbook-scoped formulas, including names used for print titles.

image