Combining multiple values to one row

building reports webintelligence
1

I have a report showing Item, Price and colour like this:

Item Price Colour

A £1 black
A £1 red
B £2 green
B £2.50 black

I want to show item A in one row, (since both item code and price are same), like this

Item Price Colour

A £1 black, red
B £2 green
B £2.50 black

How can I do this ?

Thank you

bulgaru10 :malta: (BOB member since 2006-12-15)

2

Hi,

Try this:

  1. Insert break on Item.
  2. Go to break properties and deselect Show Break Footer and Show Break Header properties.
  3. Select Block properties.
  4. Select Show Table Header property.

This doesnt concatenate the values for Color, but doesnt repeat the Item(s).

-srujana
Break.doc (24.0 KB)

srujanaj :india: (BOB member since 2010-02-10)

3

Thanks, but this is not good for me. I need to show all the colours available

bulgaru10 :malta: (BOB member since 2006-12-15)

4

Wow - this topic really comes up quite often. I guess getting the data team’s attention to prepare more suitable reporting data is getting harder and harder these days!

Try some of these links:

Atul Chowdhury (BOB member since 2003-07-07)