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: