skip to main content
OpenEdge Reporting: Query/Results Administration and Development
Results Features : Reference entry details
 
Reference entry details
This reference section documents each type of Results feature that you can redesign.
Reference entry example
Figure A–1 provides a description of the types of information supplied for each reference entry.
Figure A–1: Reference entry example
 
 
About Results
Displays the About Results dialog box. This dialog box displays information about the current product installation.
Requirements: None.
Default Menu Label: HelpAbout Results
Default Tool Bar Icon: None. Not on the default tool bar.
AdminCustomizeInterface
Displays the Preferences dialog box. This dialog box allows you to set the product name displayed in the application window title bar, set the icon image for the application, and set the Results exit behavior.
Requirements: None.
Default Menu Label: QueryCustomizePreferences
Default Tool Bar Icon: None. Not on the default tool bar.
AdminDeployment
Displays the Deployment dialog box. This dialog box allows you to set the name of the fastload file, feature definition file, and graphical configuration file.
Requirements: None.
Default Menu Label: QueryCustomizeDeployment
Default Tool Bar Icon: None. Not on the default tool bar.
AdminExportType
Displays the Standard Export dialog box. This dialog box allows you to define the standard export formats available for the current site.
Requirements: None.
Default Menu Label: QuerySite AdminStandard Export Format
Default Tool Bar Icon: None. Not on the default tool bar.
AdminFeatures
Displays the Feature Editor dialog box. This dialog box allows you to create, edit, and delete features for Results. You cannot edit or delete Results features from this dialog box.
Requirements: None.
Default Menu Label: QueryCustomizeFeatures
Default Tool Bar Icon: None. Not on the default tool bar.
AdminIntegration
Displays the Integration Procedures dialog box. This dialog box allows you to integrate Progress procedures into the Results engine to customize Results data security and interface management processing.
Requirements: None.
Default Menu Label: QueryCustomizeIntegration Procedures
Default Tool Bar Icon: None. Not on the default tool bar.
AdminLabelField
Displays the Label Field Selection dialog box. This dialog box allows you to define the parameters that determine default label selection for all tables in the connected databases.
Requirements: None.
Default Menu Label: QuerySite AdminLabel Field Selection
Default Tool Bar Icon: None. Not on the default tool bar.
AdminLabelType
Displays the Standard Label dialog box. This dialog box allows you to define the label sizes available for use in the label view.
Requirements: None.
Default Menu Label: QuerySite AdminStandard Label Size
Default Tool Bar Icon: None. Not on the default tool bar.
AdminMenuEdit
Displays the Menu Editor dialog box. This dialog box allows you to add, edit, and delete menu items from the Results menu structure. You can also use this dialog box to associate features with menu items.
Requirements: None.
Default Menu Label: QueryCustomizeMenu Layout
Default Tool Bar Icon: None. Not on the default tool bar.
AdminProgInitialize
Clears the current query and initializes the API shared variables. Use this feature prior to creating a new query in a feature procedure. This feature is designed specifically for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
AdminProgInstantiate
Initializes any unset API shared variables and all other API data structures with valid default values. Use this feature prior to executing (displaying, printing, generating, or saving) a query defined or modified in a feature procedure. This feature is designed specifically for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
AdminProgWrite4GL
Generates 4GL code for the current query and view, placing the source in a specified ASCII file. This feature is designed specifically for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
This feature has two arguments:
 
proc-name, code-format
The proc-name argument specifies the name of an ASCII file where the generated code is stored. The code-format argument must be the character g or r. The character g generates stand‑alone code. The character r generates code dependent on the Results application. You cannot generate code with the r option if the current view is the browse or form view.
AdminRebuild
Displays the Application Rebuild dialog box. This dialog box allows you to rebuild the database query configuration file and all query files when you change the schema of an application database.
Requirements: None.
Default Menu Label: QuerySite AdminApplication Rebuild
Default Tool Bar Icon: None. Not on the default tool bar.
AdminReportType
Displays the Standard Page Size dialog box. This dialog box allows you to define the page sizes available for use in the report view.
Requirements: None.
Default Menu Label: QuerySite AdminStandard Page Size
Default Tool Bar Icon: None. Not on the default tool bar.
AdminReset
Displays the Reset dialog box. This dialog box allows you to reset the Results menu system and tool bar to their default states. It also allows you to delete all user‑defined features in the current installation of Results.
Requirements: None.
Default Menu Label: QueryCustomizeReset
Default Tool Bar Icon: None. Not on the default tool bar.
AdminSecurity
Displays the Feature Security dialog box. This dialog box allows you to specify which users can access features defined in Results. For each feature, you can specify a list of user IDs that have access to the feature.
Requirements: None.
Default Menu Label: QuerySite AdminFeature Security
Default Tool Bar Icon: None. Not on the default tool bar.
AdminSubMenu
Represents the Site Administration submenu and cannot be executed from a feature procedure using the API sffire.p procedure. This menu provides access to the following administration features: AdminExportType, AdminLabelField, AdminLabelType, AdminRebuild, AdminReportType, AdminSecurity, AdminTableAlias, AdminTableRelations, and AdminWhere.
Requirements: None.
Default Menu Label: QuerySite Admin
Default Tool Bar Icon: None. Not on the default tool bar.
AdminTableAlias
Displays the Table Alias dialog box. This dialog box allows you to define or delete aliases for tables in the connected databases.
Requirements: None.
Default Menu Label: QuerySite AdminTable Aliases
Default Tool Bar Icon: None. Not on the default tool bar.
AdminTableRelations
Displays the Table Relationships dialog box. This dialog box allows you to define or limit relationships between tables in the connected databases.
Requirements: None.
Default Menu Label: QuerySite AdminTable Relationships
Default Tool Bar Icon: None. Not on the default tool bar.
AdminToolBarEdit
Displays the Tool Bar Layout dialog box. This dialog box allows you to add and delete icons on the Results tool bar. You can also use this feature to redefine the features associated with icons on the Results tool bar.
Requirements: None.
Default Menu Label: QueryCustomizeTool Bar Layout
Default Tool Bar Icon: None. Not on the default tool bar.
AdminWhere
Displays the Table Data Selection dialog box. This dialog box allows you to define static selection criteria (WHERE clause) for tables in the connected database to limit access to the data stored in those tables. The static selection criteria specified for a table executes every time you access a record in the table.
Requirements: None.
Default Menu Label: QuerySite AdminTable Data Selection
Default Tool Bar Icon: None. Not on the default tool bar.
Array
Displays the Stack Array dialog box. This dialog box allows you to format a stacked array.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldStacked Array
Default Tool Bar Icon: None. Not on the default tool bar.
BrowseView
Displays the current query, as in the browse view format.
Requirements: Active query.
Default Menu Label: ViewAs Browse
Default Tool Bar Icon:
CalcSubMenu
Represents the Add Calculated Field submenu and cannot be executed from a feature procedure using the API sffire.p procedure. This menu provides access to the following features: PercentTotal, RunningTotal, Counter, Array, Lookup, Math, StringFunc, NumericFunc, DateFunc, and LogicalFunc.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated Field
Default Tool Bar Icon: None. Not on the default tool bar.
Counter
Displays the Counter dialog box. This dialog box allows you to define a counter field for the current query.
Requirements: Active query and any view format except the label view.
Default Menu Label: FieldAdd Calculated FieldCounter
Default Tool Bar Icon: None. Not on the default tool bar.
CustomLabel
Displays the Custom Label dialog box. This dialog box allows you to define the dimensions of the label view for the active query.
Requirements: Active query and the label view.
Default Menu Label: OptionsCustom Label
Default Tool Bar Icon: None. Not on the default tool bar.
CustomReport
Displays the Custom Page Size dialog box. This dialog box allows you to define line spacing, column spacing, page length, left margin, and lines between the report sections for the report view of the active query.
Requirements: Active query and the report view.
Default Menu Label: OptionsCustom Page Size
Default Tool Bar Icon: None. Not on the default tool bar.
DataGovernor
Displays the Data Governor dialog box. This dialog box allows you to limit the number of records a query displays.
Requirements: Active query.
Default Menu Label: DataGovernor
Default Tool Bar Icon: None. Not on the default tool bar.
DateFunc
Displays the Date Function dialog box. This dialog box allows you to define an expression that yields a date value represented by a field in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldDate Function
Default Tool Bar Icon: None. Not on the default tool bar.
Exit
Exits Results. If you modified the active query and did not save it, this feature displays an alert box notifying you of the changes and prompting you to save your changes to the query. Exit behavior is governed by the AdminCustomizeInterface feature.
Requirements: None.
Default Menu Label: QueryExit
Default Tool Bar Icon: None. Not on the default tool bar.
ExportSubMenu
This feature represents the Custom Export submenu and cannot be executed from a feature procedure using the API sffire.p procedure. This menu provides access to the following custom export features: FieldDelimiters, FieldSeparators, FixedWidthFields, OutputHeaderRecord, RecordEnd, and RecordStart.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom Export
Default Tool Bar Icon: None. Not on the default tool bar.
ExportView
Displays the current query, as in the export view format.
Requirements: Active query.
Default Menu Label: ViewAs Export
Default Tool Bar Icon:
FieldDelimiters
Displays the Field Delimiters dialog box. This dialog box allows you to specify the delimiter characters for fields in a data export. Delimiter characters begin and end each field in the export.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportField Delimiters
Default Tool Bar Icon: None. Not on the default tool bar.
FieldProperties
Displays the Properties dialog box. This dialog box allows you to manipulate the display format, label, any underlying expression of a field in the active query.
Requirements: Active query and any view format except the label view.
Default Menu Label: FieldProperties
Default Tool Bar Icon: None. Not on the default tool bar.
Fields
Displays the Add/Remove Fields dialog box for the active query in the browse, form, report, or export view. The Add/Remove Fields dialog box allows you to redefine the fields included in the active query. The Fields feature displays the Label Layout dialog box for the active query in the label view. This feature requires an active query in Results.
Requirements: Active query.
Default Menu Label: FieldAdd/Remove Fields
Default Tool Bar Icon: None. Not on the default tool bar.
FieldSeparators
Displays the Field Separators dialog box. This dialog box allows you to specify the character used to separate the fields of a data export.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportField Separators
Default Tool Bar Icon: None. Not on the default tool bar.
FileClose
Closes the active query. If the active query is new or has some unsaved modifications, Results uses an alert box to prompt you to save the active query.
Requirements: Active query.
Default Menu Label: QueryClose
Default Tool Bar Icon: None. Not on the default tool bar.
FileDelete
Displays the Delete dialog box. This dialog box displays a list of queries defined in the current query directory. You can select one or more queries to delete.
Requirements: None.
Default Menu Label: QueryDelete
Default Tool Bar Icon: None. Not on the default tool bar.
FileOpen
Displays the Open dialog box. This dialog box allows you to select a query to open from the current query directory, a public query directory, or a query directory of another user. The FileOpen feature closes an existing active query prior to opening a new query.
Requirements: None.
Default Menu Label: QueryOpen
Default Tool Bar Icon:
FileSave
Saves the active query in the current query directory. If the active query is new, Results displays the Save As dialog box to allow you to name and save the active query.
Requirements: Active query.
Default Menu Label: QuerySave
Default Tool Bar Icon:
FileSaveAs
Displays the Save As dialog box. This dialog box allows you to save the active query under a specified name in the current query directory.
Requirements: Active query.
Default Menu Label: QuerySave As
Default Tool Bar Icon: None. Not on the default tool bar.
FixedWidthFields
Toggles between fixed and variable field lengths for data export operations. In a variable‑length data export, the length of the data within a column varies across the rows in the export. The maximum width of the data in the column is governed by the Format phrase specified for the column in the OpenEdge Data Dictionary. In a fixed‑width data export, the character length within columns is constant across the rows in the export. The maximum width of the data in the column is governed by the Format phrase specified for the column in the OpenEdge Data Dictionary. Values that do not fill the maximum width are padded with trailing space characters.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportFixed-width Fields
Default Tool Bar Icon: None. Not on the default tool bar.
FormView
Displays the current query as in the form view format.
Requirements: Active query.
Default Menu Label: ViewAs Form
Default Tool Bar Icon:
FrameProperties
Displays the Frame Properties dialog box. This dialog box allows you to specify a title and the vertical position of a frame associated with the browse view or form view of an active query. You can also use the Frame Properties dialog box to arrange multiple frames on the display and to designate a frame as read only.
Requirements: Active query and the form view or the browse view.
Default Menu Label: OptionsFrame Properties
Default Tool Bar Icon: None. Not on the default tool bar.
Generate
Displays the Generate 4GL dialog box. This dialog box allows you to specify the name of an ASCII file to contain the stand‑alone Progress source code generated for the active query and view in the Results product.
Requirements: Active query.
Default Menu Label: QueryGenerate
Default Tool Bar Icon: None. Not on the default tool bar.
HeadersAndFooters
Displays the Headers and Footers dialog box. This dialog box allows you to position, format, and edit the content of report headers and footers.
Requirements: Active query and the report view.
Default Menu Label: OptionsHeaders and Footers
Default Tool Bar Icon: None. Not on the default tool bar.
HelpContents
Displays the main table of contents topic of the Results help file in the help viewer.
Requirements: None.
Default Menu Label: HelpContents
Default Tool Bar Icon: None. Not on the default tool bar.
HelpSearch
Displays the Search dialog box of the help viewer. This dialog box allows you to search for help information using keywords.
Requirements: None.
Default Menu Label: HelpSearch for Help On
Default Tool Bar Icon: None. Not on the default tool bar.
Includes
Displays the Available Table dialog box followed by the Insert Code dialog box. The Available Table dialog box allows you to select a table referenced in the active query. Once you select a table, the Insert Code dialog box allows you to specify Progress code to insert after the FOR statement associated with the selected table in the active query.
Requirements: Active query.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
Information
Displays the Query Information dialog box. This dialog box displays information about the active query, including the tables and fields referenced in the query.
Requirements: Active query.
Default Menu Label: OptionsQuery Information
Default Tool Bar Icon: None. Not on the default tool bar.
Joins
Displays the Relationship Types dialog box to define the characteristics of a join in the active query.
Requirements: Active query with at least two tables.
Default Menu Label: TableRelationship Types
Default Tool Bar Icon: None. Not on the default tool bar.
LabelView
Displays the label view associated with the active query.
Requirements: Active query.
Default Menu Label: ViewAs Label
Default Tool Bar Icon:
LogicalFunc
Displays the Logical Function dialog box. This dialog box allows you to define an expression that yields a logical value represented by a field in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldLogical Function
Default Tool Bar Icon: None. Not on the default tool bar.
Lookup
Displays the Lookup Source Field dialog box. This dialog box allows you to define a lookup field to display in the active query. A lookup field is a field in the active query that you can use to establish a one‑to‑one relationship with a new table not in the active query to display one or more fields from the new table as part of the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldLookup Field
Default Tool Bar Icon: None. Not on the default tool bar.
MasterDetail
Displays the Master-Detail dialog box. This dialog box allows you to set a visual break point between tables on a report, browse, or form view.
Requirements: Active query with at least two tables and the browse, form, or report view.
Default Menu Label: OptionsMaster-Detail
Default Tool Bar Icon: None. Not on the default tool bar.
Math
Displays the Math dialog box. This dialog box allows you to define an expression that yields a numeric value represented by a field in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldMath
Default Tool Bar Icon: None. Not on the default tool bar.
Messages
Displays the Messages dialog box. This dialog box allows you to get information about a specified Progress error message.
Requirements: None.
Default Menu Label: HelpMessages
Default Tool Bar Icon: None. Not on the default tool bar.
NewBrowseView
Displays the Add/Remove Tables dialog box to allow you to define a new query and display it in the browse view.
Requirements: None.
Default Menu Label: QueryNewBrowse
Default Tool Bar Icon: None. Not on the default tool bar.
NewDuplicateView
Displays the Add/Remove Tables dialog box to allow you to define a new query. The query appears on the display in the view mode of the last active query.
Requirements: Active query.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon:
NewExportView
Displays the Add/Remove Tables dialog box to allow you to define a new query and display it in the export view.
Requirements: None.
Default Menu Label: QueryNewExport
Default Tool Bar Icon: None. Not on the default tool bar.
NewFormView
Displays the Add/Remove Tables dialog box to allow you to define a new query and display it in the form view.
Requirements: None.
Default Menu Label: QueryNewForm
Default Tool Bar Icon: None. Not on the default tool bar.
NewLabelView
Displays the Add/Remove Tables dialog box to allow you to define a new query and display it in the label view.
Requirements: None.
Default Menu Label: QueryNewLabel
Default Tool Bar Icon: None. Not on the default tool bar.
NewReportView
Displays the Add/Remove Tables dialog box to allow you to define a new query and display it in the report view.
Requirements: None.
Default Menu Label: QueryNewReport
Default Tool Bar Icon: None. Not on the default tool bar.
NewSubMenu
Provides access to the following features: NewBrowseView, NewExportView, NewFormView, NewLabelView, and NewReportView. This feature represents the New submenu and cannot be executed from a feature procedure using the API sffire.p procedure.
Requirements: None.
Default Menu Label: QueryNew
Default Tool Bar Icon: None. Not on the default tool bar.
NumericFunc
Displays the Numeric Function dialog box. This dialog box allows you to define an expression that yields a numeric value represented by a field in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldNumeric Function
Default Tool Bar Icon: None. Not on the default tool bar.
OutputHeaderRecord
Toggles Output Headers on or off for data export operations.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportOutput Header Record
Default Tool Bar Icon: None. Not on the default tool bar.
PageBreak
Displays the Page Break dialog box. This dialog box allows you to select a previously defined sort field in the active query to govern page breaks.
Requirements: Active query with sorted fields and the report view.
Default Menu Label: OptionsPage Break
Default Tool Bar Icon: None. Not on the default tool bar.
PercentTotal
Displays the Percent of Total dialog box. This dialog box allows you to select a numeric field from a table defined in the active query to be used in a percentage of total calculation.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldPercent of Total
Default Tool Bar Icon: None. Not on the default tool bar.
PrintClip
Executes the active query and sends the output to the system clipboard.
Requirements: Active query.
Default Menu Label: QueryPrintTo Clipboard
Default Tool Bar Icon: None. Not on the default tool bar.
PrintFile
Displays the Output to File dialog box. This dialog box allows you to specify the name of an ASCII file. Once you specify an output file, the active query executes and the output goes to that file.
Requirements: Active query.
Default Menu Label: QueryPrintTo File
Default Tool Bar Icon: None. Not on the default tool bar.
PrintPreview
Executes the active query and displays the output on screen in the Print Preview dialog box.
Requirements: Active query.
Default Menu Label: QueryPrint Preview
Default Tool Bar Icon:
PrintPrinter
Executes the active query and prints the query output. In Windows, this feature displays the Print dialog box to allow the user to specify a different printer.
Requirements: Active query.
Default Menu Label: QueryPrintTo Printer
Default Tool Bar Icon: None. Not on the default tool bar.
PrintPrinterNoBox
Executes the active query and prints the query output to the default system printer. In Windows, this feature sends the output to the default system printer.
Requirements: Active query.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon:
PrintSubMenu
Provides access to the following features: PrintClip, PrintFile, and PrintPrinter. This feature represents the Print submenu and cannot be executed from a feature procedure using the API sffire.p procedure.
Requirements: Active query.
Default Menu Label: QueryPrint
Default Tool Bar Icon: None. Not on the default tool bar.
ProgrammingSubMenu
Provides access to the following features: AdminCustomizeInterface, AdminDeployment, AdminFeatures, AdminIntegration, AdminMenuEdit, AdminReset, and AdminToolBarEdit. This feature represents the Customize submenu and cannot be executed from a feature procedure using the API sffire.p procedure.
Requirements: Active query.
Default Menu Label: QueryCustomize
Default Tool Bar Icon: None. Not on the default tool bar.
ReadOtherDirectory
No functionality associated with this feature. The primary use for this feature is to provide control over user access to query directories through the Feature Security mechanism. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
ReadPublicDirectory
No functionality associated with this feature. The primary use for this feature is to provide control over user access to query directories through the Feature Security mechanism. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
ReAsk
Displays the Ask At Run Time dialog box to prompt for a value to use in the selection criteria associated with the current query.
Requirements: Active query with defined selection criteria that prompts for a value at run time (Ask At Run Time). The current view must be the browse or form view.
Default Menu Label: DataRe-ask Questions
Default Tool Bar Icon: None. Not on the default tool bar.
RecentMessages
Displays the Recent Messages dialog box. This dialog box allows you to get information about recent Progress error messages.
Requirements: None.
Default Menu Label: HelpRecentMessages
Default Tool Bar Icon: None. Not on the default tool bar.
RecordAdd
No functionality associated with this feature. Use this feature to allow or deny a user, through the Feature Security mechanism, permission to add database records using a Results query in the form view. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
RecordDelete
No functionality associated with this feature. Use this feature to allow or deny a user, through the Feature Security mechanism, permission to delete database records using a Results query in the form view. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
RecordEnd
Displays the Record End dialog box. This dialog box allows you to specify the character used to signal the end of a record in the output of a data export operation.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportRecord End
Default Tool Bar Icon: None. Not on the default tool bar.
RecordStart
Displays the Record Start dialog box. This dialog box allows you to specify the character used to signal the start of a record in the output of a data export operation.
Requirements: Active query and the export view.
Default Menu Label: OptionsCustom ExportRecord Start
Default Tool Bar Icon: None. Not on the default tool bar.
RecordUpdate
No functionality associated with this feature. Use this feature to allow or deny a user, through the Feature Security mechanism, permission to update database records using a Results query in the form view. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
ReportView
Displays the report view associated with the active query.
Requirements: Active query.
Default Menu Label: ViewAs Report
Default Tool Bar Icon:
RunningTotal
Displays the Running Totals dialog box. This dialog box allows you to select a database field from a table in the active query and use it to define a calculated field that will keep a running total for the selected database field across the records returned in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldRunning Total
Default Tool Bar Icon: None. Not on the default tool bar.
Selection
Displays the Available Tables dialog box. From this dialog box, you can select a table in the active query and construct a WHERE clause that refines the data selection criteria associated with the selected table.
Requirements: Active query.
Default Menu Label: DataSelection
Default Tool Bar Icon:
SortOrdering
Displays the Sort Order Fields dialog box. This dialog box allows you to select the fields to use when sorting the data output of the active query.
Requirements: Active query.
Default Menu Label: DataSort Ordering
Default Tool Bar Icon:
StandardExport
Displays the Standard Export dialog box containing a list of predefined export formats. This dialog box allows you to select and assign a predefined export format for the export view of the active query.
Requirements: Active query and the export view.
Default Menu Label: OptionsStandard Export
Default Tool Bar Icon: None. Not on the default tool bar.
StandardLabel
Displays the Standard Label dialog box containing a list of predefined label formats. This dialog box allows you to select and assign a predefined label format for the label view of the active query.
Requirements: Active query and the label view.
Default Menu Label: OptionsStandard Label
Default Tool Bar Icon: None. Not on the default tool bar.
StandardReport
Displays the Standard Page Size dialog box containing a list of predefined page sizes. This dialog box allows you to select and assign a predefined page size for the report view of the active query.
Requirements: Active query and report view.
Default Menu Label: OptionsStandard Page Size
Default Tool Bar Icon: None. Not on the default tool bar.
StatusLine
Toggles the display of the status line located at the bottom of the Results application window.
Requirements: Active query.
Default Menu Label: ViewStatus Line
Default Tool Bar Icon: None. Not on the default tool bar.
StringFunc
Displays the String Function dialog box. This dialog box allows you to define an expression that yields a character value represented by a field in the active query.
Requirements: Active query.
Default Menu Label: FieldAdd Calculated FieldString Function
Default Tool Bar Icon: None. Not on the default tool bar.
Tables
Displays the Add/Remove Tables dialog box. This dialog box allows you to insert or remove tables from the active query.
Requirements: Active query.
Default Menu Label: TableAdd/Remove Tables
Default Tool Bar Icon: None. Not on the default tool bar.
ToolBar
Toggles the display of the tool bar located underneath the menu bar of the Results application window.
Requirements: Active query.
Default Menu Label: ViewTool Bar
Default Tool Bar Icon: None. Not on the default tool bar.
Totals
Displays the Field Aggregates dialog box. This dialog box allows you to select a field defined for the active query and define a totals operation for the selected field. You can specify the total for the field to display after a break group or in the summary section of the report output.
Requirements: Active query and the report view.
Default Menu Label: FieldAggregates
Default Tool Bar Icon: None. Not on the default tool bar.
TotalsOnly
Displays the Totals Only Summary dialog box. This dialog box allows you to define report sections as summarized. You can select one or more fields to summarize based on the last field chosen in the sort list of the active query.
Requirements: Active query with sorted fields and the report view.
Default Menu Label: OptionsTotals Only Summary
Default Tool Bar Icon: None. Not on the default tool bar.
WriteOtherDirectory
No functionality associated with this feature. The primary use for this feature is to provide control over user access to query directories through the Feature Security mechanism. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.
WritePublicDirectory
No functionality associated with this feature. The primary use for this feature is to provide control over user access to query directories through the Feature Security mechanism. It is not designed for use with the API sffire.p procedure.
Requirements: None.
Default Menu Label: None. Not in the default menu system.
Default Tool Bar Icon: None. Not on the default tool bar.