How to show data item horizontally using Repeater

[dragonfire]

I would like to show data item in myreport with seperator in between:

E.g.
Fruit
Apple, Orange, Lemon

I tried to use Repeater and embedded with a comma. But I can't think of way to remove the last comma. I can only show the report like that.

E.g.
Fruit
Apple, Orange, Lemon,

Any hints on how to remove the last seperator?

[ClintSAP]

Set items to repeat to have the comma at the beginning rather than the end and unless it is the first record. You can put a rank data item in the query and use that to check whether it is the first record or not.

[dougp]

I make the comma its own data item:

Code: [Select]

case when running-count (distinct [Fruit]) < count (distinct [Fruit] for report) then ', ' end