User`s guide

• "&" (allows any character or space, and requires the entry of a character in the parameter value).
• "C" (allows any character or space, and does not require the entry of a character in the parameter
value).
• ". , : ; - /" (separator characters). Inserting separator characters into an edit mask is something
like hard coding the formatting for the parameter field. When the field is placed on the report, the
separator character will appear in the field object frame, like this: LLLL/0000. This example depicts
an edit mask that requires four letters followed by four numbers.
• "<" (causes subsequent characters to be converted to lowercase).
• ">" (causes subsequent characters to be converted to uppercase).
• "\" (causes the subsequent character to be displayed as a literal). For example, the edit mask
"\A" would display a parameter value of "A." If the edit mask is "00\A00," then a valid parameter
value would consist of two digits, the letter "A," and then two additional digits.
• "Password". Allows you to set the edit mask to "Password," you can create conditional formulas
specifying that certain sections of the report become visible only when certain user passwords
are entered.
Note:
Some of the edit mask characters require that you enter a character in their place (when entering a
parameter value), while others allow you to leave a space, if needed. For example, if the edit mask
is 000099, you can enter a parameter value with four digits, five digits, or six digits, since the '9' edit
mask character does not require the entry of a character. However, since '0' does require such an
entry, you could not enter a parameter value with less than four digits.
5.
Click OK.
6.
Return to the Field Explorer, and drag the parameter into the report.
21.12.8 Creating a saved-data record filter using parameter fields
You can design your report so that users can filter fields and records without refreshing information
from the database. Saved-data record filters combine the use of saved data selection formulas and the
Parameter Panel.
This feature is particularly useful for several reasons:
• It allows users to filter and re-filter report data without leaving the canvas of the report.
• It eliminates processing demand on the database.
• It reduces the time users spend waiting for data to be filtered.
• It allows users to filter records in the report even if they do not have a connection or rights to access
the database at the time of viewing.
When planning to include a saved-data record filter in your report, it is important to consider the following
points:
2012-03-14485
Parameter Fields and Prompts