Answer Posted / prabhukumar
Level span is used to eliminate duplicates in data, in Cognos it is used repeat grouped item. Using level span we can see the grouped data group by group.
For example, when country and city are both grouped, you can choose to show the country name each time .
-- the country changes, by spanning Country by Country
-- the city changes, by spanning Country by City
-- there is a new record, by specifying no spanning
Spanning one grouped column by another column is helpful if the second
column contains many items.
Steps
Open the report that you want.
Click the column for which you want to set the group span.
In the Properties pane, click the Group Span property and click the
column you want to span.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What are the main services provided by application tier?
What is model?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What is called materialized view?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Why cognos scenario is used?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What do you understand by the term 'dynamic cube'?
What are the themes in a data warehouse?
how to explain health care project and which reports we can create in health care doain?
What is the function of model design accelerator?
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?
What are products of cognos?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?