User`s guide

Managed list of val-
ues
Unmanaged list of values
Description
Business ViewsCommand objectsReport fields
Well suited.
You can define filtering
within the source Busi-
ness View.
Well suited.
You can define filtering
within a command ob-
ject. (That command
objects return the data
for all levels in the list
is not a problem for
single-level lists.)
Not well suited.
Because report fields
cannot be filtered, any
filtering of the list that
you require must be
done outside of Crystal
Reports in a database
view.
Single-level code ta-
bles. (A table that has
hundreds of semi-static
values in a single lev-
el.)
Well suited.
Business-View-based
lists of values can sup-
port both filtering and
level-by-level data re-
trieval.
Well suited.
Provided that the total
data volume for all lev-
els in the list is not too
large. If there is too
much data, you could
encounter performance
issues because com-
mand-object-based
lists of values retrieve
data for all levels in one
trip to the database.
Well suited.
Provided that the data
filtering is done outside
of Crystal Reports, re-
port fields are well suit-
ed to multi-level cascad-
ing code tables be-
cause they retrieve da-
ta one level at a time.
Multi level-cascading
code tables. (A table
that has hundreds of
semi-static values in
multiple levels.)
Well suited.
Partially scheduled lists
of values excel in this
situation, where the se-
mi-static part of the da-
ta can be scheduled,
and the most dynamic
part can be retrieved
on-demand.
Not well suited.
Because command ob-
jects retrieve their data
in one trip to the
database, there could
be performance issues
when you use them
against very large ta-
bles.
Well suited.
Provided that the filter-
ing is done outside of
Crystal Reports in a
database view, and
provided that there is a
multi-level hierarchy to
the data.
Fact tables. (These ta-
bles tend to be very
large, dynamic tables
with millions of values
in multiple levels.)
21.3.3 Lists of values and prompt groups contrasted
2012-03-14460
Parameter Fields and Prompts