Sub-Query Cognos 10

Hello Experts,
I'm new to the Cognos world and need some guidance. From the attached file I want to combine column O into a single comma delimited field. I think this is going to involve an SQL script and a temp table to hod the data, but any better suggestions are great. The current report is a Excel/SQL based solution which I'm charged with migrating from to a new Cognos based one.
The final report could contain several hundred different customer with different material numbers. In the end I want to search the new field for certain item numbers.
Who is Participating?
RWrigleyConnect With a Mentor Commented:
I think you're getting off onto the wrong foot with this approach.  Why do you want to combine the data into a single field?  That's going to restrict the usability of the final report.  Why not instead use a master-detail report or a repeater?

In other words, what is the ultimate objective of the report you're trying to build?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.