Demo 080 — direction=column

Type	Template	Report
Excel	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

{"A":{"LEVEL":0,"SUB_NODES":[{"NAME":"GRP A","ATTR":{"LEVEL":1,"SUB_NODES":[{"NAME":"0 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP A","CAPTION":"<Caption 1 />","DATE":"2020-10-21","SUM1":5971.44,"SUM2":5021.46}}},{"NAME":"1 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP A","CAPTION":"<Caption 4 />","DATE":"2020-10-21","SUM1":9476.79,"SUM2":3683.27}}},{"NAME":"2 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP A","CAPTION":"<Caption 5 />","DATE":"2020-10-21","SUM1":4604.0,"SUM2":5525.85}}},{"NAME":"3 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP A","CAPTION":"<Caption 8 />","DATE":"2020-10-21","SUM1":5476.81,"SUM2":406.18}}}],"DATA":{"GROUP":"GRP A","CAPTION":"","DATE":"0000-00-00","SUM1":51058.08,"SUM2":29273.52}}},{"NAME":"GRP C","ATTR":{"LEVEL":1,"SUB_NODES":[{"NAME":"0 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP C","CAPTION":"<Caption 2 />","DATE":"2020-10-19","SUM1":2276.75,"SUM2":7717.2}}},{"NAME":"1 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP C","CAPTION":"<Caption 6 />","DATE":"2020-10-19","SUM1":2159.71,"SUM2":2260.94}}},{"NAME":"2 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP C","CAPTION":"<Caption 10 />","DATE":"2020-10-19","SUM1":5451.87,"SUM2":4061.85}}},{"NAME":"3 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP C","CAPTION":"<Caption 12 />","DATE":"2020-10-19","SUM1":1196.35,"SUM2":522.46}}},{"NAME":"4 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP C","CAPTION":"<Caption 13 />","DATE":"2020-10-19","SUM1":7686.95,"SUM2":2727.98}}}],"DATA":{"GROUP":"GRP C","CAPTION":"","DATE":"0000-00-00","SUM1":37543.26,"SUM2":34580.86}}},{"NAME":"GRP B","ATTR":{"LEVEL":1,"SUB_NODES":[{"NAME":"0 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP B","CAPTION":"<Caption 3 />","DATE":"2020-10-20","SUM1":3031.38,"SUM2":445.22}}},{"NAME":"1 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP B","CAPTION":"<Caption 7 />","DATE":"2020-10-20","SUM1":2490.3,"SUM2":6388.81}}}],"DATA":{"GROUP":"GRP B","CAPTION":"","DATE":"0000-00-00","SUM1":11043.36,"SUM2":13668.06}}},{"NAME":"GRP D","ATTR":{"LEVEL":1,"SUB_NODES":[{"NAME":"0 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP D","CAPTION":"<Caption 9 />","DATE":"2020-10-18","SUM1":689.66,"SUM2":518.6}}},{"NAME":"1 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP D","CAPTION":"<Caption 11 />","DATE":"2020-10-18","SUM1":4573.55,"SUM2":5436.0}}},{"NAME":"2 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP D","CAPTION":"<Caption 14 />","DATE":"2020-10-18","SUM1":978.18,"SUM2":295.55}}},{"NAME":"3 ","ATTR":{"LEVEL":2,"SUB_NODES":[],"DATA":{"GROUP":"GRP D","CAPTION":"<Caption 15 />","DATE":"2020-10-18","SUM1":71.12,"SUM2":8878.56}}}],"DATA":{"GROUP":"GRP D","CAPTION":"","DATE":"0000-00-00","SUM1":12625.02,"SUM2":30257.42}}}],"DATA":{"GROUP":"GRP A","CAPTION":"","DATE":"0000-00-00","SUM1":168404.58,"SUM2":161669.79}},"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}]}

).

---

Generate demo 080

direction=column

Template ZXXT_DEMO_080-XLSX Row count 1–25 rows

Request preview

Purpose

Demo ZCL_XTT_DEMO_080 expands a table or tree horizontally instead of vertically. The ;direction=column directive is supported by ZCL_XTT_EXCEL_XLSX for XLSX and XLSM output.

Build the data

The ABAP data is prepared exactly as in the grouped-tree example:

    SET HANDLER on_prepare_tree_05 ACTIVATION abap_true.

    GET REFERENCE OF lt_rows INTO lr_table.
    ls_root-a = zcl_xtt_replace_block=>tree_create(
     it_table      = lr_table       " from 7.5 REF #(lt_rows)
     iv_fields     = 'GROUP'   ).   " Name of the fields delimited by ;

    SET HANDLER on_prepare_tree_05 ACTIVATION abap_false.

Mark the template

The difference is in the template. Add {R-T;direction=column} (or the equivalent marker for your block) to the table or tree that must grow across columns.

• Table

• Tree

The generated output expands horizontally:

• Table

• Tree

Prevent an unwanted offset

If generated data shifts downward, place non-empty anchor cells to the left of the template column. The cell labelled I stay here in the demo illustrates the required anchor.