Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is difference between page break and section report? What is main advantage datawarehousing over oracle?

1074


Write various indexes used in cognos?

1024


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

1953


How to create a cube in Transformer? What is the process? Please mention process thank u

1815


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

2241


What are all the types of gateway used in Cognos?

1082


What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2193


Can you define materialized view?

1105


What is meant by alternate drill down with ex?

1142


What are all the types of hierarchies?

1179


What is a Cube?

1188


what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

3006


can we insert all types of charts in a list report? what r the realtime prompts?

2264


What is a dimension?

1080


What is defined as data mining?

1079