My Oracle Support Banner

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

Last updated on JANUARY 28, 2020

Applies to:

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

Symptoms

 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:
Code:

<!ELEMENT EMPDEPTXML (G_DEPTNO)+ >
<!ELEMENT G_DEPTNO (DEPTNO, (G_EMPNO+))+ >
<!ELEMENT DEPTNO (#PCDATA) >
<!ELEMENT G_EMPNO (EMPNO, ENAME)+>
<!ELEMENT EMPNO (#PCDATA) >
<!ELEMENT ENAME (#PCDATA) >

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.

Cause

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.