BI Publisher (MOSC)

MOSC Banner

How to group results

edited Nov 25, 2020 9:33PM in BI Publisher (MOSC) 1 comment

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

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center