Operation Manual

Parameter Fields and Prompts
Advanced parameter features
23
Crystal Reports User’s Guide 461
• Enter Boolean values using the following format: TRUE or FALSE.
• Enter Number values exactly as they will appear in the field.
• Enter Currency values exactly as they will appear in the field.
• Enter Date values to match the format used on-screen. If the format is
unspecified, enter as Date (Year, Month, Day). For example, Date (1997, 5,
21). To access the calendar, click the drop-down arrow beside the date.
• Enter Time values to match the format used on-screen. If the format is
unspecified, enter as Time (Hour, Minutes, Seconds AM/PM). For
example, Time (4:32:12 PM). You can also select the unit of time and
then use the up and down arrows to scroll through the numbers.
• Enter DateTime values using the following format: Date (Year, Month,
Day), Time (Hour, Minutes, Seconds AM/PM). For example, Date (1997,
5, 21), Time (4:32:12 PM). You can also enter DateTime values by using
the associated drop-down arrow to access the calendar, and the up and
down arrows to scroll through the time.
Note: The drop-down arrow to access the calendar for dates and the up
and down arrows to scroll for times will only be available if you have the
correct version (4.70 or later) of comctl32.dll.
To use the current value displayed, click OK, or, to use a different value from
the one displayed, type a new value in the text box, and click OK.
• If the parameter field is range limited, then you can only enter values
within a certain range. The range limit is specified in the Set Default Value
dialog box when creating or editing a parameter.
• If the parameter is a string value type, you can limit the values the user is
able to enter by using the length limit option or by using an edit mask to
restrict the format.
The program now runs the report using the new value(s) you specified.
Advanced parameter features
There are a variety of ways that parameters can be used within a report. This
section covers some of the advanced methods of using parameters:
• “Creating a parameter with multiple prompting values” on page 462.
• “Applying conditional formatting using parameter fields” on page 462.
• “Creating a report title using parameter fields” on page 463.
• “Specifying single or ranges of values” on page 464.
• “Incorporating a parameter into a formula” on page 465.