1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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)?

Question Posted / vinod

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

what is power prompt in cognos ep7series?what is the use of this?

0 Answers   HCL,

what is the difference between application based and web based in cognos?can you please give a example from out of EP 7 series and 8 series?genrel exampel please?

2 Answers   HCL,

what is the difference between aggregation and roll up aggregation?

1 Answers  

Explain the Difference Between Bursting and Scheduling?

1 Answers  

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

3 Answers   TCS, Thomson Reuters,




I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?

5 Answers   SAIC,

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

0 Answers   IBM,

where do we see the run time of the report ?

2 Answers  

How to move reports one server to another server?

2 Answers   Wipro,

What is the difference between group and associare?

0 Answers  

how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview

2 Answers   IBM,

What is the difference between Standard and Metrics folder?

0 Answers  

For more Cognos Interview Questions Click Here
Categories