If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to show data item horizontally using Repeater

Started by dragonfire, 14 Aug 2006 06:27:35 AM

Previous topic - Next topic

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:

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