GeekInterview.com
Series: Subject: Topic:
Question: 21 of 211

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
Asked by: itspaddu | Member Since Apr-2011 | Asked on: Jun 23rd, 2011

View all questions by itspaddu

Showing Answers 1 - 9 of 9 Answers
raju

Answered On : Jul 13th, 2011

by using pivot option

  
Login to rate this answer.
Ramani

Answered On : 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.

  
Login to rate this answer.
shailendra32

Answered On : Oct 14th, 2011

View all answers by shailendra32

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.

  
Login to rate this answer.
jagade

Answered On : Jan 5th, 2012

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

  
Login to rate this answer.
raja

Answered On : Jan 19th, 2012

There is no option for convert crosstab to list

Yes  1 User has rated as useful.
  
Login to rate this answer.
suchismita

Answered On : Mar 5th, 2012

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

Yes  1 User has rated as useful.
  
Login to rate this answer.
Ashish

Answered On : 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

  
Login to rate this answer.
mani

Answered On : 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...

  
Login to rate this answer.
srihari

Answered On : 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.

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.