BI Publisher (MOSC)

MOSC Banner

Group the similar records set as one record in BI Publisher report

edited Sep 25, 2015 10:01AM in BI Publisher (MOSC) 3 commentsAnswered

Hello Experts,

I would love to post my question/requirement here to get your suggestions.I have one interesting requirement/scenario to achieve in BI Publisher report template.

Customer would like to see one set/single record instead of multiple duplicate records in report.here is an example.

We have Hierarchy as:Quote-->Quote Item-->Quote Item XA.

Quote has multiple line items as below

Quote-->Line 1                                                         Price 1                                      Price 2                          Qty

              Line 1.1 -SS-DD                                       $400                                          $500                               1

                    Line 1.1.1 -20v-16amp                          $150                                          $300                               1

                    Line 1.1.2 -180kVA                              $250                                          $200                                1                       

              Line 1.2 -SS-DD                                       $400                                          $500                                1

                    Line 1.2.1 -20v-16amp                          $150                                          $300                                1

                    Line 1.2.2 -180kVA                              $250                                          $200                                 1

              Line 2

             Line 2.1 -SS-DD                                       $400                                          $500                                 1

                    Line 2.1.1 -20v-16amp                          $150                                          $300                                1

                    Line 2.1.2 -180kVA                              $250                                          $200                                 1                       

              Line 2.2 -SS-DD                                      

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