How to convert crosstab into list?

Hi , can any one tell how to convert crosstab into list?
what is the main use of unlocking the report?
what is the meaning of repeater & repeater table and when r they useful?

plz answer these if any one knows?



best regards
paddu

Questions by itspaddu

Showing Answers 1 - 15 of 15 Answers

raju

  • Jul 13th, 2011
 

by using pivot option

  Was this answer useful?  Yes

Ramani

  • Sep 30th, 2011
 

If you are working on query studio, then you cannot convert the crosstab report into list report, unless you choose to do the "undo" option.
But you can do this conversion in the Report Studio.

  Was this answer useful?  Yes

shailendra32

  • Oct 14th, 2011
 

In Report Studio, It simple to convert list to crosstab.
But there is no built in option to convert crosstab to list report.This work only one way.

I found on possible solution which is as given below.
Take a blank list, then link it to the crosstab query and rebuild it.Easy but some mouse moving needed.

  Was this answer useful?  Yes

jagade

  • Jan 5th, 2012
 

According my knowldge that one is not possiable, list to crosstab we can do it.

  Was this answer useful?  Yes

raja

  • Jan 19th, 2012
 

There is no option for convert crosstab to list

suchismita

  • Mar 5th, 2012
 

it is not possible to convert crosstab to list. but the reverse is true.

Ashish

  • Mar 15th, 2012
 

We use unlocking option when we need to :-
-- insert more than one query item in a single column
-- insert any object like HTML object or Text object in a column.
these are some examples and we can use that unlocking in many more cases.

Moreover there is no automatic way to convert crosstab to list .What you can do is to create a list report using the same query

  Was this answer useful?  Yes

mani

  • Apr 18th, 2012
 

there is no option for converting a crosstab to list but we can do this by using cross tab space.....at the designing page it should look like a cross tab only but when u run the report the report will shown to u in list format....

u can do this by unlocking and insert a cross tab space at the intersection point and in that add a text item with the desired query item name....

Regards,
Mani...

  Was this answer useful?  Yes

srihari

  • Apr 6th, 2013
 

It is not Possible any studios in congnos convert to crosstab into list is not possible but list is converted into crosstab its possible. and also list is converted into Repeater table.

  Was this answer useful?  Yes

Prachi

  • Dec 30th, 2013
 

To change the crosstab report back to a list report, click the top row, and then click the
ungroup button on the toolbar.

  Was this answer useful?  Yes

Onkar Kulkarni

  • Feb 12th, 2014
 

Direct conversion available in Cognos 10 onwards

  Was this answer useful?  Yes

Prathap

  • Jun 11th, 2015
 

We cannot change crosstab into List again. Only we can change list into Crosstab.

  Was this answer useful?  Yes

Anil Kumar

  • Jul 28th, 2016
 

We don't have any feature to change the cross tab report to List.
only we change the list report to Cross tab with Pivot

  Was this answer useful?  Yes

Manogna

  • Aug 30th, 2017
 

We cant convert crosstab to list but reverse is possible by using pivot table function

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions