How To Create Crosstab Report In Cognos 10 Report Studio

• Home
• Interview Questions
• Data Warehouse
• Cognos

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

• First
• Prev
• Next
• Last

Showing Answers 1 - 15 of 15 Answers

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.

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.

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

There is no option for convert crosstab to list

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

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

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...

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.

There is no direct option to convert a cross tab to list but it can be accomplished indirectly by using cross tab space...We can only change the appearance....

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

Onkar Kulkarni

• Feb 12th, 2014

Direct conversion available in Cognos 10 onwards

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

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

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

Related Answered Questions

•   Need to find the list of employees who is from finance department having 1200 pincode
•   123abc456xyz convert to 123456 ---file1 abcxyz ----file2
•   How to list employees names hired after a certain date
•   Convert 1 file into 3 files
•   Spliting the file in datastage
•   Correlated sub query
•   SQL query to convert single row from multiple tables into single row in a table
•   Report studio restrict user to add new data item
•   Convert date format
•   Xen desktop real time issues

Related Open Questions

•   What is the tradeoff using a linked list
•   Convert any two numbers into words and perform arithmetic operation
•   How to differentiate GL, AP objects based on key terms - peoplesoft
•   Concatenate two circularly single linked list into one circularly linked list
•   Queries for truck booking
•   Enable uft/QTP addiins at runtime
•   Redis server database data storage
•   Computer network node packet transmission
•   Subclass of component class
•   Find a solution in c, c++, c#

• Open Questions
• Answered

How To Create Crosstab Report In Cognos 10 Report Studio

Source: http://www.geekinterview.com/question_details/85539

Posted by: gordonopoetinat1997.blogspot.com

Share this post