My Oracle Support Banner

XML Data source: Reports Wizard Misses Fields in Sub-group/Sub-element (Doc ID 289649.1)

Last updated on MAY 08, 2020

Applies to:

Oracle Reports Developer - Version and later
Information in this document applies to any platform.


 1. Use of XML Query in Reports 9i by specifying a valid DTD and XML file in Reports Wizard.

2. The DTD has elements with further sub-elements defined in order to simulate a reports structure that
contains more than one group ( subgroups / parent-child ).

3. Reports Wizard shows only the parent columns for selection and not the columns that belong to the
sub-groups / child groups.

4. The following example DTD has been designed for emp table of scott schema:

The DTD used is similar to:


When Reports Wizard shows the columns available, only DEPTNO, G_EMPNO are shown.
EMPNO, ENAME that have been specified under G_EMPNO are not shown.
G_EMPNO is itself shown as a text field.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.