User`s guide
This formula prompts for a value for the parameter field {?SortField}. If you enter "C", the formula
will sort by the City field. If you enter "R" it will sort by the Region field. If you enter anything else,
or do not enter anything at all, the formula will sort by the Country field.
For more information see "If statements" in the online help.
6.
Place the formula in the Report Header section of the report and select Suppress (No
Drill-Down) in the Section Expert so that it does not print.
7.
Click Sort Records.
8.
Choose your formula and click Add.
9.
Click OK.
Now when you run the report, the program will prompt you for a sort field, the formula will return a value
based on your selection, and the sort facility will use that value as your sort field.
21.12.7 Defining entry type and format using the Edit Mask
1.
On the View menu, click Field Explorer.
2.
Select Parameter Fields and click New.
The Create New Parameter dialog box appears.
3.
Enter the Name and value Type.
4.
For a string parameter field, you can choose to enter an edit mask in the Edit mask field, rather
than specifying a range.
An edit mask can be any of a set of masking characters used to restrict the values you can enter
as parameter values (the edit mask also limits the values you can enter as default prompting values).
You can enter any of the following masking characters, or any combination of them:
• "A" (allows an alphanumeric character and requires the entry of a character in the parameter
value).
• "a" (allows an alphanumeric character and does not require the entry of a character in the
parameter value).
• "0" (allows a digit [0 to 9] and requires the entry of a character in the parameter value).
• "9" (allows a digit or a space, and does not require the entry of a character in the parameter
value).
• "#" (allows a digit, space, or plus/minus sign, and does not require the entry of a character in the
parameter value).
• "L" (allows a letter [A to Z], and requires the entry of a character in the parameter value).
• "?" (allows a letter, and does not require the entry of a character in the parameter value).
2012-03-14484
Parameter Fields and Prompts