Print Page - Concatinate Row Values

Title: Concatinate Row Values
Post by: Pramod on 11 Mar 2010 04:26:42 AM

Hi All
I have a doubt can you help me out with this
I have a Column Territory and I have to Concatinate the values of this column
e.g.
Territory
Canada
USA
Japan
Germany

I wanna create a dataitem which concatinate all the values in the column
Territory Data Item1
Canada Canada,USA,Japan,Germany
USA Canada,USA,Japan,Germany
Japan Canada,USA,Japan,Germany
Germany Canada,USA,Japan,Germany

can we do this?
Is there any performance factor which will effect the report due to this calculation.

Title: Re: Concatinate Row Values
Post by: Naven on 11 Mar 2010 04:55:54 AM

Hi Pramod,

This might help you.

http://www-931.ibm.com/bin/newsletter/tool/landingPage.cgi?lpId=2487&open&cm_mmc=6455-_-n-_-vrm_newsletter-_-11022_143660&cmibm_em=dm::

Regards,
Naveen

Title: Re: Concatinate Row Values
Post by: addpremkumar on 12 Mar 2010 02:55:46 AM

Pramod,

There was a function in Framework manager which will concatinate all the row values.

Please search for that..

--Prem

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Pramod on 11 Mar 2010 04:26:42 AM