Jump to content
Changes to the Jaspersoft community edition download ×

Report showing duplicates record.


abhimanyu.prasad

Recommended Posts

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.
 
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...