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
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
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?
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
How about a repeater table?
You could easily hide the column headers in the repeater table.