COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: trooper642 on 12 Mar 2009 08:42:39 AM

Title: repeater / trim
Post by: trooper642 on 12 Mar 2009 08:42:39 AM
I’m using the repeater but I want to delete last trailing comma.

In my query I have a data item ‘Division No’ shown below and I want to display a comma between each Division No but I want to remove the last trailing comma at the end. When I use this data item within a repeater in RS I get an output like the following.

Division No
001, 002, 003,

Division No: [Customer Initiations].[Division].[Division No]+', '

-Bryan
Title: Re: repeater / trim
Post by: dinos on 08 Dec 2009 01:58:27 PM
Hi,

Please let me know if you figured out how to do this?