Report showing duplicates record.

0

I have the XML as datasource,

<RescueInfo>
<aprRate>43</aprRate>
<planName>WLPLan101</planName>
<RuleDetails dataStr="list">
<RescueValue_Pesos>96.44</RescueValue_Pesos>
<Status>Success</Status>
<YearValue>1</YearValue>
<CumulativePremium>3016.2</CumulativePremium>
<RuleName>RescueValueFirstYear</RuleName>
<AnnualPremium>3016.2</AnnualPremium>
<FaceAmt>11221</FaceAmt>
<StatusCode>1</StatusCode>
</RuleDetails>
<RuleDetails dataStr="list">
<RescueValue_Pesos>96.6</RescueValue_Pesos>
<Status>Success</Status>
<YearValue>2</YearValue>
<CumulativePremium>7329.37</CumulativePremium>
<RuleName>RescueValueSubsequentYearAge_2</RuleName>
<AnnualPremium>4313.17</AnnualPremium>
<FaceAmt>16046.03</FaceAmt>
<StatusCode>1</StatusCode>
</RuleDetails>
</RescueInfo>
<RescueInfo>
<aprRate>45</aprRate>
<planName>WLPLan102</planName>
<RuleDetails dataStr="list">
<RescueValue_Pesos>96.44</RescueValue_Pesos>
<Status>Success</Status>
<YearValue>3</YearValue>
<CumulativePremium>5555.2</CumulativePremium>
<RuleName>RescueValueFirstYear</RuleName>
<AnnualPremium>5555.2</AnnualPremium>
<FaceAmt>55555</FaceAmt>
<StatusCode>1</StatusCode>
</RuleDetails>
<RuleDetails dataStr="list">
<RescueValue_Pesos>96.6</RescueValue_Pesos>
<Status>Success</Status>
<YearValue>4</YearValue>
<CumulativePremium>6666.37</CumulativePremium>
<RuleName>RescueValueSubsequentYearAge_2</RuleName>
<AnnualPremium>66666.17</AnnualPremium>
<FaceAmt>6666.03</FaceAmt>
<StatusCode>1</StatusCode>
</RuleDetails>
</RescueInfo>
 
The report showing,
plan1
yearValue of ruletag1
yearValue of ruletag2
yearValue of ruletag3
yearValue of ruletag4
plan2
yearValue of ruletag1
yearValue of ruletag2
yearValue of ruletag3
yearValue of ruletag4
 

The op should be,

plan1
yearValue of ruletag1
yearValue of ruletag2
plan2
yearValue of ruletag3
yearValue of ruletag4
 
I have made the ruledetails node as record node and added the year as node with creation of dataset.
 
abhimanyu.prasad's picture
Joined: Nov 25 2013 - 2:18am
Last seen: 4 years 7 months ago

0 Answers:

No answers yet
Feedback