Amount Column repeating the same amount for each case

I am using an XML to render a report. Each row should display a single amount per case; for example:

row 1 .--->  validation number   caseid   payee name  check amount     check no

row 2 .--->        13331                   1234       john_name             120                   blank

row 3 .--->        13332                   1234       john_name             240                   blank

row 4 .--->        13333                   1234       john_name             340                   blank

row 5 .--->        13334                   2222       Mark_name             10                   blank

row 6 .--->        13335                   2222       Mark_name             20                   blank

row 7 .--->        13336                   2222       Mark_name             30                   blank

But it is display wrongly like this:

The Expression code looks like:

a!localVariables(
  local!data: reject(
    fn!isnull,
    a!forEach(
      ri!reportData,
      if(
        rule!CheckIsNullOrEmpty(fv!item.paymentRefValidationNo),
        if(
          index(fv!item,"checkPrtSeq",{})=1,
          fv!item,
          null
        ),
        {}
      )
    )
  ),
  local!xml: {
    "<report>" & "<name>" & cons!RPT_NAME_003_op_CHECK_REGISTER & "</name>" & "<runDate>" & todate(local(now(), "America/Chicago")) & "</runDate>" & "<runTime>" & totime(local(now(), "America/Chicago")) & if(
      isindaylightsavingtime(todate(now()), "America/Chicago"),
      " CDT",
      " CST"
    ) & "</runTime>" & "<totalField>" & "Total: " & dollar(
      if(
        rule!APN_isBlank(local!data),
        0,
        sum(index(local!data, "paymentAmt", {}))
      )
    ) & "</totalField>" & "<reportDate>" & tostring(todate(ri!reportDate)) & "</reportDate>" & "<columnOneName>" & "Batch No" & "</columnOneName>" & "<columnTwoName>" & "Validation Number" & "</columnTwoName>" & "<columnThreeName>" & cons!DRO_CSO_FIELD_HEADER_CASE_ID & "</columnThreeName>" & "<columnFourName>" & "Payee Name" & "</columnFourName>" & "<columnFiveName>" & "Check Amount" & "</columnFiveName>" & "<columnSixName>" & cons!DRO_CSO_FIELD_HEADER_CHECK_PRT_NO & "</columnSixName>" & "<columnSevenName>" & " " & "</columnSevenName>" & "<columnEightName>" & " " & "</columnEightName>" & "<columnNineName>" & " " & "</columnNineName>" & "<columnTenName>" & " " & "</columnTenName>" & "<columnElevenName>" & " " & "</columnElevenName>" & "<columnTwelveName>" & " " & "</columnTwelveName>" & "<columnThirteenName>" & " " & "</columnThirteenName>" & "<columnFourteenName>" & " " & "</columnFourteenName>" & "<columnFifteenName>" & " " & "</columnFifteenName>" & "<columnSixteenName>" & " " & "</columnSixteenName>" & a!forEach(
      items: local!data,
      expression: {
        "<row colOneData='" & index(fv!item, "batchNo", {}) & "' " & "colTwoData='" & index(fv!item, "paymentValidationNo", {}) & "' " & "colThreeData='" & index(fv!item, "caseId", {}) & "' " & "colFourData='" & stripwith(index(fv!item, "payeeName", {}), "'") & "' " & "colFiveData='" & if(
          rule!APN_isBlank(index(local!data, "paymentAmt", {})),
          " ",
          dollar(index(local!data, "paymentAmt", {}))
        ) & "' " & "colSixData='" & index(local!data, "checkPrtNo", {}) & "' " & "colSevenData='" & " " & "' " & "colEightData='" & " " & "' " & "colNineData='" & " " & "' " & "colTenData='" & " " & "' " & "colElevenData='" & " " & "' " & "colTwelveData='" & " " & "' " & "colThirteenData='" & " " & "' " & "colFourteenData='" & " " & "' " & "colFifteenData='" & " " & "' " & "colSixteenData='" & " " & "'/>"
      }
    ) & "</report>"
  },
  local!output: stripwith(tostring(local!xml), ";"),
  local!output
)

Any help will be greatly appreciated.

Thank you.

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data