BI Publisher (MOSC)

MOSC Banner

How to group parent value by child value in BI Publisher?

edited Jan 19, 2020 4:00AM in BI Publisher (MOSC) 5 commentsAnswered

I have a requirement where I have to group a parent value by its child value but I wonder if this is even possible. I know how to group by a parent value level but I've never done this before.

Any help or idea is welcome.

My expected output would be like: 

Supplier: Bernardo Quintana

Line | Item

1      MP000233

2      MP000129

rnardoItem  Quintana Bernardo Quintana

I attach the file which I'm working with and also the RTF.

<RequisitionLineVO>         <RequisitionLineVORow>            <LineNumber>1</LineNumber>            <ItemDescription>MP000233</ItemDescription>            <RequisitionLineDetailVO>               <RequisitionLineDetailVORow>                    <RequisitionLineId>30009</RequisitionLineId>                    <Supplier>Bernardo Quintana</Supplier>               </RequisitionLineDetailVORow>            </RequisitionLineDetailVO>        </RequisitionLineVORow>         <RequisitionLineVORow>            <LineNumber>2</LineNumber>            <ItemDescription>MP000129</ItemDescription>            <RequisitionLineDetailVO>               <RequisitionLineDetailVORow>                    <RequisitionLineId>30010</RequisitionLineId>                   <Supplier>Bernardo Quintana</Supplier>               </RequisitionLineDetailVORow>            </RequisitionLineDetailVO>
Tagged:

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