Cognos: Vertical to Horizontal Data in report

[brandi]

Hi Folks
:)
I have figured out part of this solution but I need help to complete it.  I have data that shows:

Job               Name
Teacher         Mary
Teacher         Bob
Student         Joe
Student         Sara

I want it to show:
Teacher Mary, Bob
Student Joe, Sara

I can use a repeater table, but it repeates the job name. I only want that to appear once. So it shows up as:

Teacher mary      Teacher Bob
Student Joe         Student Sara

Can someone confirm how I can get it to show up in the BOLD sample area above in red??

[Ras_MA]

So, you're trying to transpose the data.   

Instead of the repeater, try this:

• Create a query that returns Job, Name and filter it on 'Teacher'
• Copy the query and change filter the to 'Student'
• Add a union object and feed it from the first two queries
• Point your list to the resulting query

Caveats:

• This solution assumes that you have a definable and stable set of jobs.  It requires maintenance at the query level if a new job is added to the datasource.
  Just because you can doesn't mean you should.  A better solution would be to transpose the values in the datasource.

[brandi]

Thank you for the reply.

The sad part is that we don't know what data will be coming through. So filtering out the queries isn't an option. You are right, doing it on the DB is a solution. I just wanted to see if putting it in  RS would work.

I did find a solution though. I use Repeater tables... This will actually get the row of data to show exactly as it does on the DB rows. Which is what they are looking for. The sad part is that they want to export this to Excel. When I do, it takes each "repeater item" and puts it in it's own individual column. For each repeater cell, they want to all be in one column. So that may push this work to be done on the DB side.