Converting rows and columns like Transpose option in MS-Excel

[peewan]

Hi There,

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

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


Is there a way to do this in Cognos?

[Andrei I]

Cognos has an easy Transpose for Crosstab only.

For a List you can use Repeater Table which would require some work.
See an attached example with screenshot and report (ver. 10.1.1 ) against Audit DB