How to group results
I'm trying to create a BI Publisher report using Oracle BI Publisher Desktop (Word) with a JDE XML schema that has this structure.
- R007000
- Section 1
- Section 1.1
- FileName_ID
- Section 1.2
- Section 1.3
- B_Type
- B_Number
- B_Amount
- Section 1.3
- Section 1.1
- Section 1
XML Sample:
Section<R007000>
<Section 1>
<Section 1.1>
<FileName_ID1>Group 1</FileName_ID1>
</Section 1.1>
<Section 1.2>
<Section 1.3>
<type>1</type>
<number>12</number>
<amount>10.00</amount>
</Section 1.3>
</Section 1.2>
<Section 1.2>
<Section 1.3>
<type>10</type>
<number>120</number>
<amount>100.00</amount>
</Section 1.3>
</Section 1.2>
<Section 1.1>
<FileName_ID1>Group 2</FileName_ID1>
</Section 1.1>
<Section 1.2>
<Section 1.3>
<type>4</type>
<number>6</number>
<amount>7.00</amount>
</Section 1.3>
</Section 1.2>
<Section 1.1>
</Section>
What I need to do is show the data from each Level 1.3 but it needs to be grouped on each FileName_ID, from Level 1.1 so the output will looks something like: