combine multiple rows in to a single row

building reports webintelligence
1

hi,

i have 2 fields in the database adtype and quantity the sample data is below

Ad Type , quantity
entertainment 1000
news 2000
business 3000
All 4000
Life styles 5000

i want to create a webintelligence report in a summarized i.e make the 5 rows in to a single row like below
Ad Type Quantity
entertaiment,news,business,All,Life styles 15000

can you please help me with how to get it

Thanks in advance

manjub (BOB member since 2008-10-17)

2

this has to be done at database level(Data Flattening)
what database are you using?

Thanks,
Zaif

zaif235 :us: (BOB member since 2010-06-15)

3

This should provide a headway…

Hey Manju…Always try searching before posting…

Cheers!!

nitin_gons :india: (BOB member since 2009-05-26)