The Outer XML Tag property specifies the name of the selected group, with a LIST_ prefix. The purpose of the outer XML tag is to enclose all tags and data from instances of a group object. In a report, you may have repeating instances of a group object (for example deptno, which outputs 10, 20, 30, and so on). The outer XML tag simply encapsulates data for all repeating instances.
Applies to |
Groups |
Default |
<LIST_G_[groupname]> |
Required/Optional |
Optional |
Suppose you have a report which contains the following query:
SELECT * from EMP
You have decided to view this data as a group-left report with DEPTNO as the first-level group and JOB as the second-level group.
For the purposes of this example, you wish to reverse the order of output for the groups DEPTNO and JOB, from ascending to descending.
From the data model, select the column DEPTNO and open the Property Inspector.
Change the Break Order property from Ascending to Descending.
Repeat the first two steps for the column JOB.
Your data model will look like the following:
You now want to view the hierarchical structure of your XML output for groups in your report. Since you have made the group G_JOB a child of group G_DEPTNO, you decide to collapse all elements within the <LIST_G_DEPTNO> outer group in order to expand the structure of data one level at a time.
- <MODULE1>
- <LIST_G_DEPTNO>
+
<G_DEPTNO>
+
<G_DEPTNO>
+
<G_DEPTNO>
</LIST_G_DEPTNO>
</MODULE1>
In the XML example above, you can see that for the group G_DEPTNO (represented by the outer tag <LIST_G_DEPTNO>) there are three unique instances of DEPTNO data. Now you wish to see the next-level group, G_JOB, which is a child of G_DEPTNO. If you expand the first XML tag <G_DEPTNO> you will see the following:
- <MODULE1>
- <LIST_G_DEPTNO>
-
<G_DEPTNO>
<DEPTNO>30</DEPTNO>
+
<LIST_G_JOB>
</G_DEPTNO>
+
<G_DEPTNO>
+
<G_DEPTNO>
<LIST_G_DEPTNO>
</MODULE1>
Just as <LIST_G_DEPTNO> contains repeating instances of <G_DEPTNO>, + <LIST_G_JOB> contains repeating instances of <G_JOB>. If you expand the element + <LIST_G_JOB>, you will see the following XML output in its place:
-
<LIST_G_JOB>
+
<G_JOB>
+
<G_JOB>
+
<G_JOB>
-
</LIST_G_JOB>
If you expand the first G_JOB element (+<G_JOB>), you will see the following XML output in its place:
-
<G_JOB>
<JOB>SALESMAN</JOB>
+
<LIST_G_EMPNO>
</G_JOB>
As you can see, <G_JOB> contains instances of another repeating group, <G_EMPNO>. If you expand +<LIST_G_EMPNO>, instances of <G_EMPNO> appear. In this case, there will be no further child groups, but there are a number of column values available for the G_EMPNO group. The XML output looks like the following:
-
<LIST_G_EMPNO>
-
<G_EMPNO>
<EMPNO>7499</EMPNO>
<ENAME>ALLEN</ENAME>
<MGR>7698</MGR>
<HIREDATE>20-FEB-81</HIREDATE>
<SAL>1600</SAL>
<COMM>300</COMM>
</G_EMPNO>
</LIST_G_EMPNO>
The outer element <LIST_[groupname]> is useful as a container for repeating groups.
Copyright © 1984, 2005, Oracle. All rights reserved.