How to concatinate rows in a webi report

building reports webintelligence
1

Hello-
I am looking for a solution where I need to concatenate rows…
Here is what i need to achive.

Coloum1 Coloum2 Coloum3(Total)
NJ 123 2
NJ 124 2
NJ 136 3
NJ 1234 2

This need to be represented like:

Coloum1 Coloum2 Coloum3(TOTAL)
NJ 123,124,136… 9

Any help is greatly appreciated.
Thanks in advance.
Viz

viz (BOB member since 2008-12-03)

2

Is this a more detailed version of this question or are they supposed to be separate issues…

Dave Rathbun :us: (BOB member since 2002-06-06)

3

They are two different questions. :crazy_face:

viz (BOB member since 2008-12-03)

4

Did you try using a horizontal table? Refer this topic

Jansi :india: (BOB member since 2008-05-12)

5

Full client /DeskI has more flexibility than WebI.
The requirement you have is not achivable even in DeskI.

It has to be done via store procedures or you will have to utilize derived table in universe to achive this.

KhoushikTTT :us: (BOB member since 2005-02-24)

6

Thanks For the reply.
can you give a detail description of how it can be done at universe level.

viz (BOB member since 2008-12-03)

7

Create a derived table based on corelated sub queries

KhoushikTTT :us: (BOB member since 2005-02-24)