Group the similar records set as one record in BI Publisher report
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