Gemma3004

Please can someone help?

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

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.