XML - Create a comma separated string of a field

[Gemma3004]

Hi, I am using Jasper Studio with an XML data source.

I would like to know how to amalgamate the questionId field (when the field appears on multiple rows as shown below) into a comma separated string so it can appear on my report as "1,2,3"

rather than on separate lines like

1

2

3

Can I amalgamte into a string via a variable?

Here is how my xml dataset looks like:

<Answer Category="xxxx" Id="xxxxxx" questionId="1">

<Answer Category="xxxx" Id="xxxxxx" questionId="2">

<Answer Category="xxxx" Id="xxxxxx" questionId="3">

Please help as I have a deadline to meet and I am really struggling.

Thank you

[Gemma3004]

Please can someone help?

[zellers]

Add a variable with calculation set to "System", Expression:

$V{Variable_1} != null ? $V{Variable_1} + "," + $F{questionId} : $F{questionId}.toString()[/code]

And Evaluation time on the Text Field to "Report".

 

Demo attached.