Design Studio report-to-report (row)

[former_member191047]

Sometimes you'd like to see details based on a row selection from a crosstab.

This requires a main data source and one or more extra (detail) data sources. All must be based on the same query. The UID code from the query is used.

Looking in the original query on row level the structure contains UID 00O2TGRLUPXL0WRL473HUPDXY. This is what will be used in the filter.

In this example two crosstabs are used.

- CROSSTAB_1 as source crosstab with data source DS_1.

- CROSSTAB_2 as target crosstab with data source DS_2.

Settings for the initial crosstab.

The code for the On Select event in the initial crosstab.

var lv_select =  me.getSelectedMember("00O2TGRLUPXL0WRL473HUPDXY");

DS_2.setFilter("00O2TGRLUPXL0WRL473HUPDXY", lv_select);