| Author |
Message |
Jacob
Newbie
Joined: 16 May 2008
Location: United States
Online Status: Offline
Posts: 4
|
  
Topic: How Can I Rank in Crystal
Posted: 16 May 2008 at 9:59am |
Does anyone know how the ranking function works in Crystal?
I'm trying to develop a Sales report by Territory. The report has a "% Attainment" for each territory. I need to rank the territories by "% Attainment". The report is sorted in territory number order and cannot be changed. The % Attainment is calculated on Grouping line.
|
 IP Logged |
|
|
|
Lugh
Senior Member
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
|
Posted: 19 May 2008 at 6:09am |
|
Let me try to restate the question. You have a report. It is currently both grouped and sorted by territory. You want to sort the groups by Attainment, so that the territory with the highest Attainment appears first. Is this correct?
If "% Attainment" is a relatively simple summary calculation, then this is possible. Go into the Group Sort Expert, choose "All" in the drop-down on the left, and choose the appropriate summary function on the right. If it is not a simple calculation, particularly if it involves referencing other formulas, running totals, or variables, then you probably cannot sort the entire report on it. As a note, though, you may be able to create something like a cross-tab in the report footer which will sort this way.
If this is not your goal, please re-state your original question, possibly with a brief example.
|
| IP Logged |
|
Jacob
Newbie
Joined: 16 May 2008
Location: United States
Online Status: Offline
Posts: 4
|
Posted: 19 May 2008 at 6:20am |
The current report is grouped and sorted by Territory Number. The % Attainment is a formula recalculated calculated each month. The Territories are then ranked on % Attainment. The requirement is to keep the report sorted by Territory number.
Exp:
Territory % Attainment Rank
11A00 89% 3
11B00 96% 2
11C00 72% 4
11D00 100% 1
|
| IP Logged |
|
Lugh
Senior Member
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
|
Posted: 19 May 2008 at 6:40am |
|
Ah. Now I see what you mean. A different animal altogether.
Off-hand, I don't know how to do this. Let me try a few things and get back to you.
|
| IP Logged |
|
Jacob
Newbie
Joined: 16 May 2008
Location: United States
Online Status: Offline
Posts: 4
|
Posted: 19 May 2008 at 7:01am |
|
Using Excel or a Business Intelligence tool like Brio there is a Rank function that makes this very easy to do. I don't think Crystal has such a function? When creating sales reports this is a very important requirement.
|
| IP Logged |
|
twinkle
Newbie
Joined: 16 Jun 2008
Location: United Kingdom
Online Status: Offline
Posts: 32
|
Posted: 16 Jun 2008 at 11:33am |
Does anyone have a solution to this ranking problem -
i have a similar problem, but mines involves formulas and running totals
most of my results are grouped Edited by twinkle - 16 Jun 2008 at 3:59pm
|
| IP Logged |
|
Jacob
Newbie
Joined: 16 May 2008
Location: United States
Online Status: Offline
Posts: 4
|
Posted: 16 Jun 2008 at 11:46am |
|
After talking to several technical support people at Business Objects they basically said Crystal IX can't handle ranking. They told me to try Crystal 2008, saying 2008 has many new features. You need XP in order to use Crystal 2008. That's what I'm waiting on.
|
| IP Logged |
|
twinkle
Newbie
Joined: 16 Jun 2008
Location: United Kingdom
Online Status: Offline
Posts: 32
|
Posted: 17 Jun 2008 at 1:59am |
Hi,
i have CR XI... i am inserting a graph to show a trend, could i use Rank on the graph? My graph will be displayed on the footer!
|
| IP Logged |
|
BrianBischof
Admin Group
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
|
Posted: 17 Jun 2008 at 2:53pm |
|
It appears from the research that Jacob has done that CR XI isn't capable of doing this.
|
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
|
| IP Logged |
|
|
|
