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: {
"" & "" & cons!RPT_NAME_003_op_CHECK_REGISTER & " " & "" & todate(local(now(), "America/Chicago")) & " " & "" & totime(local(now(), "America/Chicago")) & if(
isindaylightsavingtime(todate(now()), "America/Chicago"),
" CDT",
" CST"
) & " " & "" & "Total: " & dollar(
if(
rule!APN_isBlank(local!data),
0,
sum(index(local!data, "paymentAmt", {}))
)
) & " " & "" & tostring(todate(ri!reportDate)) & " " & "" & "Batch No" & " " & "" & "Validation Number" & " " & "" & cons!DRO_CSO_FIELD_HEADER_CASE_ID & " " & "" & "Payee Name" & " " & "" & "Check Amount" & " " & "" & cons!DRO_CSO_FIELD_HEADER_CHECK_PRT_NO & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & "" & " " & " " & a!forEach(
items: local!data,
expression: {
"
"
}
) & " "
},
local!output: stripwith(tostring(local!xml), ";"),
local!output
)
Any help will be greatly appreciated.
Thank you.
