Displaying multiple rows in a single cell

building reports desktopintelligence
1

All,

I have a data provider that returns a single dimension column having 3 rows of data.

Sample Data

Country
US
UK
Japan

I need to create a cell which displays the data as US-UK-Japan
This is a special requirement and hence the data provider returns a single column.
Is there any trick which can be used to display the data.I did think of using rowid but still couldn’t come up with a solution.
The database is Oracle and Business Objects 6.1b

Help is appreciated.

Thanks

Jimmy

jim_dav2002 (BOB member since 2003-03-28)

2

This has been discussed MANY times. It isn’t possible without the use of some sort of stored function at the backend. Try doing a search for multiple rows.

There was a really good posting on this topic about 4 weeks ago. I’ll try to find it for you.

Steve Krandel :us: (BOB member since 2002-06-25)

3

Here is the link Steve was talking about.

A database level solution

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