Display results on single line

[sleepy]

Hi,

I current have a set or results that gives me

row#1  orange
row#2  apple
row#3  banana

I need to be able to display the results as:

FRUIT_BASKET: orange,apple, banana

ie all 3 fields on a single line with commas inbetween.

Does anyone know how I do this?

Cheers,
steve  ;D

PS: Im currently using Cognos 8, Oracle 10g

[MFGF]

Hi,

User a repeater (from the toolbox).

Best regards,

MF.

[BRAINMan]

Hi Sleepy,

another option would be to pivot your data. If you have your fruits in only one column, write a little view in FrameworkManager to get each fruit in one column. In ReportStudio you will now get three columns. Hide the list itself and just show the list headings with values in it. Add a text element in front of the three column list header and type "FRUITS:" in it. You could also put all three columns in one column and then separate it with text elements with an comma in it.

Hope this helps.

If you are facing problems in pivoting SQL, just let me know, ok?!

Regards, BRAINMan

[almeids]

BRAINMan,
   Just curious: are you referring to a method of "pivoting" dynamically in SQL, without advance knowledge of a column's content?  If so, I'd love to hear about it.
thanks,
Steve