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
Explain is there any comparison available for cognos reportnet vs crystal reports?
How to Reset Pagenumbers in one report.
Define datastores in cognos?
what is model and say about process how to create model and how to test model?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What is the difference between static and dynamic conditions?
What is Additive function?
what is catalog and types of catalogs in cagnos and which is better?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
how to test reports in cognos?
What is meant by drill down?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
how to perform single sign in cognos by using url?
What are the types of security?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?