HP Intelligent Management Center Standard Software Platform - Manual (Page 596)

For example, a list of countries could be a dynamic prompt, while a
hierarchical list of countries, regions, and cities could be a dynamic prompt
with a cascading list of values.
Crystal Reports supports three data sources for list-of-values objects:
• Report fields (only for unmanaged reports).
• Command objects (only for unmanaged reports).
• Business Views (only for managed reports).
A list of values can have one or more levels. If there are multiple levels in
the list of values, then each level constrains the next.
You can think of a list of values as the definition of the data needed to
populate all levels of a cascading list. In Crystal Reports, a cascading
relationship is defined by a single list-of-values object, not by multiple queries
that are linked together by a common key. Although the list of values is
defined as a single entity, data is not necessarily fetched from the data source
in a single query.
Note:
• List-of-values objects are not affected by report record selection or group
selection formulas. These formulas affect the report data, not data used
for prompt-time lists of values.
• If a data connection is broken or reset, Crystal Reports does not attempt
to create or update the dynamic list-of-values object and instead reverts
to a static list.
List-of-values types
There are two different types of list-of-values objects:
• Unmanaged lists of values are stored within each report file.
If you do not have BusinessObjects Enterprise, or if you never publish
your reports to BusinessObjects Enterprise, you use an unmanaged
list-of-values object. Unmanaged list-of-values objects can use report
fields or command objects as a data source.
• Managed lists of values are stored within BusinessObjects Enterprise.
596 Crystal Reports 2008 SP3 User's Guide
Parameter Fields and Prompts 23
Understanding lists of values