Result of select in iReport on one line

[mimya_sin]

I need to transfer the result of a select with several rows to put them on one line. Here an example

the result of the select (select number, letter from table) is

number letter

1    a

1    b

2    c

2    d

2    e

3    f

 

the report has to be like this

1  a,b

2   c,d,f

3   f

 

notice please that I don't know the exact number of the letter associated with the number. So I cannot solve it with a join of the table with itself!

Thanks for helping!

 

[jbo_master]

You can insert a so called "report group" to your report and group by your number-object.

[mimya_sin]

jbo_master
Wrote:
 

You can insert a so called "report group" to your report and group by your number-object.

with report group I could group for example the rows for the number 2 like this

2  c

    d

    e

and every row will generate a new line. I need 'c' 'd' and 'e' to be in the report at the same line! like this:

c, d, e.

so how to do??

mimya_sin