BusinessObjects Board

Drill report presentation

building reports webintelligence legacy 1/2
#1

Hi Guys,
This forum has always helped me in times of need.
Need urgent input on following:

Initial data display:

Date--------------------Time--------------------Attibute
27/08/2006------------14:45:59:001----------11
27/08/2006------------14:45:59:004----------22
27/08/2006------------14:45:59:051----------33
28/08/2006------------12:23:12:001----------44
28/08/2006------------12:23:12:588----------55
29/08/2006------------15:15:59:001----------66

Would it be possible to display the above as following upon summarisation/drill:

Date--------------------Time-----------Attibute
27/08/2006------------14:45:59------11, 22, 33
28/08/2006------------12:23:12------44, 55
29/08/2006------------15:15:59------66

Considering the data in “Attribute” column has to be concatenated on the fly?

Thanks in advance.
:?:

hsharma :australia: (BOB member since 2005-09-21)

#2

This has been asked many times before. Unfortunately, unless the number of items to be aggregated is constant, there is no way to do this.

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