10. In Report studio ,how to get the top 20 employees in using list report
Row number – if only list
Rank
Running-count
- 1 Answers
- 3070 Views
- Data Semantics, I also Faced
- E-Mail Answers
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 |
can anybody tell me..how to enter with fake exp..wt r all the documents to carry while attending the interview..how to answer that i am working in..
How can I change reports to another package???
wt is scope relationship?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
what is catalog and types of catalogs in cagnos and which is better?
how to change the colour of the bar in charts...?
How to hide the prompts
plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?
------------- How to identify the Revenue Column in Report?
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
Teradata 
