[XML - Create a comma separated string of a field]

Please can someone help?

[XML - Create a comma separated string of a field]

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

[How do you auto adjust columns in a crosstab]

I have set up a crosstab.  The row is a 'Question' and the column is a 'Person', the measure is the 'Answer' to the question.

There could be upto a max of 4 columns becuase there could be 4 persons providing their own answer to the question.

How do I set up the crosstab so that depending on the columns/Persons, the columns resize equally to the width of the page?  So if there are only 2 columns/persons, then they should be equally spaced across the page and if the are 4 columns/persons, then again all columns should be equally spaced across the page.