Categories
- All Categories
- 89 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.1K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 51 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Groups in rtf template
Summary
Groups in rtf template
Content
Hi,
I have this XML data :
<PARENT_GROUP>
<CHILD_GROUP_1>
<DATA_11> DEP1 </DATA_11>
<DATA_12> DEP2 </DATA_12>
<DATA_13> 2 </DATA_13>
<DATA_14> 4 </DATA_14>
<CHILD_GROUP_1/>
<CHILD_GROUP_2>
<DATA_21>ABC</DATA_21>
<DATA_22> 100 </DATA_22>
<DATA_23> DEP1 </DATA_23>
<CHILD_GROUP_2/>
<CHILD_GROUP_2>
<DATA_21> XYZ </DATA_21>
<DATA_22> 200 </DATA_22>
<DATA_23> DEP2 </DATA_23>
<CHILD_GROUP_2/>
<CHILD_GROUP_2>
<DATA_21> PQR </DATA_21>
<DATA_22> 300 </DATA_22>
<DATA_23> DEP1 </DATA_23>
<CHILD_GROUP_2/>
<CHILD_GROUP_2>
<DATA_21> LMN </DATA_21>
<DATA_22> 400 </DATA_22>
<DATA_23> DEP2 </DATA_23>
<CHILD_GROUP_2/>
</PARENT_GROUP>
It should display like :
ITEM
|
QUANITY | TAX NAME | TAX QNT |
DEP1 | 2 |
ABC
PQR |
100
300 |
DEP2 | 4 |
XYZ
LMN |
200
400 |
How will i do that?
Answers
-
use left grouping while creating rtf template instead of above grouping, duplicates rows will suppress. if you still find issues, please upload template and xml.Thanks
0 -
That XML doesn't look right to me.
Either way, you should just be able to nest your groups to achieve what you want.
I know I have done something similar in the past however i'm out of the office so can't get you the exact syntax.0