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

What is Stich Query in Reportnet?

10 Answers  


Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.

4 Answers  


After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

1 Answers   IBM,


how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

0 Answers   IBM,


Is cognos models are version compatible?

2 Answers  






Guys... which difficult you faced in your projects that should be difficult to you not to others... any one can explain but should be clear steps... and with examples... how you handle that......?

0 Answers   CTS,


Explain about scorecarding?

0 Answers  


what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,


What is a business view? and what is the difference b/w business view and folder?in cognos report life cycle when it will be involved ?

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,


What are the batches and it’s details?

0 Answers  


how can you create a report like if country=india then true if contry=spain then false?

2 Answers   Syntel,


Categories