Symptom
I am trying to build a report which has a pivot. In Query Workspace, the descendants of selected elements (e.g. the children of a parent organization in Organization sturcture) are indented. However, when I use that query in Report Designer (table based on published data component), the indentations go away. How can I make the indentations appear in Report Designer as well?
Resolution
Please use a Composite Query component in Report Designer and enable the the "Indent Labels" setting in the Edit Component menu.
See below:
Keywords
Composite query
Pivot query
Indent, Indentation
Report designer
elements, descendants , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , How To