10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
Rank
Running-count
Answer Posted / adiubar
Open report studio >> add data item in the sequence EMP name , Emp Number , salary >> sort the salary column in descending order
Go to query explorer >> drag a data item from the toolbox >> open the data item you have created and use rank function on salary
i.e. Rank(salary)
Now add a detailed filter value [Data Item1] <= 20 and run the report .
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Write various indexes used in cognos?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
How to create a cube in Transformer? What is the process? Please mention process thank u
hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com
What are all the types of gateway used in Cognos?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
Can you define materialized view?
What is meant by alternate drill down with ex?
What are all the types of hierarchies?
What is a Cube?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
can we insert all types of charts in a list report? what r the realtime prompts?
What is a dimension?
What is defined as data mining?