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 220.127.116.11 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:
<!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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!