User`s guide

Note:
You can specify a prompt instead of a constant by clicking the arrow next to the number. When you
select a prompt, the user must enter the ranking number when they run the query. For more
information on prompts, see Building prompts.
6.
Drag the object that provides the calculation context for the measure to the For each box.
This dimension is optional.
Note:
To display the "For each" box, click the arrow to the right of the "Based on" measure.
7.
Drag any objects that you want to include in the WHERE restriction to the white area of the ranking
outline. For more information on the WHERE restriction, see the explanation under What is a
subquery?.
16.6.4.2 Ranking parameters
The following table describes the parameters from left to right in the ranking:
DescriptionParameter
Ranking order.
Top - ranks in descending order.
Bottom - ranks in ascending order.
Top/Bottom
The number of records to return in the ranking.
For example, the top 10.
Number of records
The object used in the ranking. For example, if
the object is Region and the ranking is Top 10,
the ranking returns the top 10 regions.
Ranking object
The measure by which the ranking object is
ranked. For example, if the measure is Revenue
and the object is Region, Crystal Reports ranks
regions by the amount of revenue they generate.
Based on
2012-03-14359
Building Queries