i am trying to create a ranking report using crystal report 10, this ranking report should show all the employees revenue for the current month ranked from the largest revenue to the smallest. i used NthLargest funtion to pull up the largest, and the 2nd largest and so on, but also i need to pull up the name of the person who made that revenue.
previously, i used excel spreadsheet to do that by using index and match funtion together, but i don't know what function or combinnation of funtions i should use.
ex. joe 84646
Sam 21636
because joe's revenue is larger than sam's, joe shows on the top list.
please, advice
Creating ranking report using Crystal report10
Hot Topic
Visual Studio
- Error while trying to serialize Cyclic Dependencies
- How do we automate a build that uses a .pfx keyfile?
- Creating a VSTO customization for Online/Offline use
- Can't Reset All Settings in VS2005
- VSTO project does not appear in "VSTOprojects" CAS list
- Rendering in pixel space
- Installing VS2005 Deletes SourceSafe in VS2003
- PowerToys for the Visual Studio 2005 Class Designer and Distributed System Designers
- "Reload" listobject after UnList()
- IIS Hosted WCF service & WLBS
Creating ranking report using Crystal report10
vmadhavapeddi
Is the Revenue field a calculated field Or do we just read it straight from the database.
A few things that come to mind. The simplest being to add the fields to the report and simply sort by Revenue.
The other way to do it is to group on Employee and then create a TopN report based on the Revenue field.
Keith - Business Objects