Side by side comparison in Report Studio

[akp]

Hi There,

Is there any way we can Transpose rows to columns in Report Studio like we do in MS-Excel?

There are 20 columns in a query and it is giving a list result properly but it is hard to compare these data for two or more items in rows. So, I need the first column of the output as the headings and other columns containing one or more set of dynamic data.

I know this is possible if I change the list to a repeater table but there the headers repeat for each set of data. I need the header only once.

Normal Output:

Name       Salary Band    Location
----------------------------------
Marc        10                   London
----------------------------------
Henry       20                   USA
----------------------------------
Peter       30                   Denmark

Desired Output:

Name             Marc       Henry       Peter
--------------------------------------------
Salary Band   10           20            30
-------------------------------------------
Location        London    USA         Denmark


Any ideas?

Thanks,
--
Sapp

[sunny bachan prasad]

It will be good if you do it in the DB side.
Please refer the below mention link it will solve your problem.

http://www.cognoise.com/index.php?topic=17712.0

[bdbits]

Not entirely sure I follow, but if you select the list container and choose Structure > Pivot List to Crosstab, does that do what you want?

[akp]

Sorry for a late response ... I was on vacation  :D

@sunny bachan prasad: yes, I know we may need to do this at database level but wanted to know if there is any option available in Cognos only so that it can be re-used in further development requirements.

@bdbits: Sorry, that is not what I wanted. If you check the illustration properly, you will understand the requirement.

Thanks,
--
Sapp

[Lynn]

How about a repeater table?

[Robl]

You could easily hide the column headers in the repeater table.