10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
Rank
Running-count
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 |
How we check the errors before running the report?
In a Single page we are having 3 list. While running each has to populated in separate page?
What is Local Cache and how does it help in performance tuning
What is called a slice?
what are the limitations of cognos reportnet?
11 Answers IBM, Nestle, TCS,
How can create users and permissions in cognos?
What is the difference between macros and prompt?
How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.
How can we improve performance in framework manager level?
how to explain health care project and which reports we can create in health care doain?
What are the differences between main Cognos 8.2 and 8.3 ?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?