What do you do to make a report result in showing 4
different regions in an xl sheet in individual sheets(like
Region1-sheet1,Region2-Sheet2 soon)?

Answers were Sorted based on User's Feedback



What do you do to make a report result in showing 4 different regions in an xl sheet in individual..

Answer / ishpreet

Select the regions data item and click on "Set Page Break"
from structure menu.
Run report in Excel you will have different sheets for each
region.

Is This Answer Correct ?    17 Yes 1 No

What do you do to make a report result in showing 4 different regions in an xl sheet in individual..

Answer / ashwini

Create a page set, specify the query and grouping.

Is This Answer Correct ?    5 Yes 0 No

What do you do to make a report result in showing 4 different regions in an xl sheet in individual..

Answer / test

Select the Regions data item and click on "Set Page Break"
from structure (Menu).
Run report in Excel you will have different sheets for each
region.

Is This Answer Correct ?    1 Yes 0 No

What do you do to make a report result in showing 4 different regions in an xl sheet in individual..

Answer / khushbu rangari

Hi,
For Every region create a new page.

The steps are :
1.create new report like list ,chart or crosstab.
2.Add data its to it.
3.Place your cursor to page explorer and click to Report
Pages add new page from Insertable Objects Pane. repeat
this step for every region.
4. add data items to every page.
5. validate your report and Run it in excel.

Thanks,
khushbu

Is This Answer Correct ?    1 Yes 7 No

What do you do to make a report result in showing 4 different regions in an xl sheet in individual..

Answer / basha

I think we need to create tabbed reports for this
requirement.

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Cognos Interview Questions

Hi,Can anyone tell me training centre for cognos in Mumbai?

4 Answers  


Can i apply drill through on master detail relationship report?

2 Answers   TCS,


How to hide value prompt box and list when run report?

4 Answers   IBM,


If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  


What is Fullouterjoin?

0 Answers  






2. What functional area you worked on.

0 Answers   IBM,


How to schedule the report twice in a day?

2 Answers   Cognizant,


wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?

0 Answers  


How to pass parameter value into html design page?

1 Answers  


--------------How to do Report Testing in Reports?

1 Answers   IBM,


What is the size of the cube?

0 Answers  


how to change the colour of the bar in charts...?

3 Answers   IBM,


Categories