My Preferences: Editors category, Filter

From the Editors, Filter category of the My Preferences Dialog Box, you can change the following default settings for this project:

• Show advanced qualification option: When this check box is selected, this option is enabled in the Filter Editor. When the Filter Editor is opened, users can choose to create several types of filters, including an attribute qualification, a set qualification, and a shortcut to a filter or report. Users can also create an advanced qualification, which is either a custom expression or a joint element list qualification. Both of these types of advanced qualifications require a certain level of knowledge to create them correctly.

  • A joint element list qualification is a filter that contains elements from more than one attribute, joined together into a filter. This filter type allows users to create a fine-tuned filter, but the attributes and elements selected must make sense when combined together.

  • A custom expression requires knowledge of mathematical expression syntax. This filter type is usually used with the ApplyComparison and ApplySimple functions and related syntax.

• Show all available prompt buttons: When this check box is selected, all available prompt buttons are displayed in the Filter Editor.

• Show the tip box on the qualification dialog boxes: When this check box is selected, tips appear in appropriate qualification dialog boxes. These tips appear in the otherwise empty area at the bottom of the Filter Editor window. Tips include helpful information on what to do in the given section of the Filter Editor that is currently displayed, as well as providing alternative ways to proceed.

• Trim leading spaces of a value: When this check box is selected, the leading spaces for a value are trimmed. The SQL generated when a report is executed will automatically trim any leading space that appears at the beginning of a data value.