Summarized data - Grouping problem

[Good Friend]

Hello All,

I have a requirement where I need to show a summarized single row of data instead of showing multiple rows based on the dates. I have attached the image.

From the image I have highlighted few dates, if we take Activity code as 'EEE', instead of showing the 6 rows for different dates, it should show
8:20:45 pm - Begin date and 8:31:07 pm - End Date as a single row and all the other dates should be eliminated. The problem here is, we also have same activity 'EEE' repeated after 'FFF' which should be shown as a different activity.
Activity 'EEE' highlighted in 'Yellow' should also be shown as single row with Begin Date - 8:20:45 pm and End Date - 8:31:07 pm and
Activity 'EEE' highlighted in 'Green' should also be shown as single row with Begin Date -  8:34:28 pm and End date - 8:47:38 pm.
I'm facing difficulty in grouping these and making activity as unique identifier with rank, as the codes are repeating and they should be shown separately.

Can some one please assist me in moving forward with this task. Please do the needful and I appreciate the same.

[Lynn]

It seems the basis for separating the EEE groups is due to the presence of FFF in between, or rather the contiguous nature of each group of rows rather than any particular data item.

I'd suggest you revisit the database side of things to get some ETL process in place that can use procedural code to step through records and identify the appropriate groups. Cognos is going to generate set based SQL statements which is not at all procedural.

[Good Friend]

Thanks Lynn. Appreciate your timely response. I still need to figure out the best code that fixes this issue ;)