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

Using separate value and description fields
It is common in relational databases to make use of code fields that represent
values. These codes are often numeric or text strings that cannot be read
by your users. For such cases, you can create separate value and description
fields in your list of values definition. You set the value field to the parameter;
the description field appears in the prompting dialog box. How the description
field appears in the prompting dialog box is controlled by the prompt option
"Prompt with Description Only." When set to True, only the descriptions are
visible; when set to False, both the values and descriptions are visible.
To set separate value and description fields
1. Open the sample report called Group.rpt.
Sample reports are located on the Business Objects Technical Support
web site
http://support.businessobjects.com/samples/ .
2.
In the Field Explorer, select Parameter Fields and click New.
The Create New Parameter dialog box appears.
3. Enter a name for the parameter in the Name field.
This example uses Customer Name.
4. In the List of Values area, click Dynamic.
5.
Click Insert and, in the Value field, select Customer ID.
6. In the Description field, select Customer Name.
7. In the Value Options area, set the Prompt with Description Only option
to True.
8. Click OK.
When your users see this prompt in the prompting dialog box, they do not
see values from the Customer ID field (the field on which the parameter is
based), but rather, they see a list of customer names.
616 Crystal Reports 2008 SP3 User's Guide
Parameter Fields and Prompts 23
Working with lists of values