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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between native sql and cognos sql?

499


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

5969


2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1711


what is degenerate key in oracle ?whare do we use it?

2055


What is cognos powerhouse?

579






what is the difference between list report and crosstab report?

700


What is a Datastore in Cognos?

790


Write types of folders present in cognos?

562


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

640


Define the slice and dice?

564


Define datastores in cognos?

550


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1639


What is meant by alternate drill down with ex?

614


Can you define cognos decision stream?

596


How can we create a dynamic column name in cognos?

523