User`s guide

DescriptionParameter
The operator that specifies the relationship be-
tween the Filter object and the Filter By object.
Because of database restrictions you cannot use
certain combinations of operators and Filter By
objects together. For example, if you use the
Equal To operator with a Filter By object that re-
turns multiple values, the database rejects the
SQL because this type of subquery requires the
Filter By object to return one value only.
In cases where the generated SQL is rejected by
the database, you see an error message showing
the error description returned by the database.
Operator
An additional condition that constrains the list of
values of the Filter By object. You can use ordi-
nary report objects, predefined conditions or ex-
isting query filters (including subqueries) in the
WHERE condition.
WHERE condition (optional)
If there is more than one subquery, determines
the relationship between the subqueries.
AND - the conditions in all of the subqueries must
be satisfied.
OR - the conditions in any one of the subqueries
must be satisfied.
Relationship operator
16.6.3 What is a database ranking?
Database rankings allow you to answer questions like "what are the top three customers, based on the
revenue they generated for each year?" at the query level, without the need to return data that falls
outside the ranking to Crystal Reports. You can then filter this data using a ranking.
When you rank data you sort and filter it according to ranking criteria. This process is much like selecting
Top or Bottom N values when sorting groups in Crystal Reports. For more information, see Selecting
top or bottom N groups or percentages.
2012-03-14357
Building Queries