Results menu

The following menu commands are available:

Retrieve All

Select Retrieve All to finish retrieving all the query results data. When retrieving large amounts of data, unless otherwise specified, only the first 100 data rows are retrieved.

Font

Opens the Font page of the Layout Properties window where you can view and change the font attributes of your selection within the query results.

Format

Opens the Format page of the Layout Properties window where you can view and change the formatting options for the selected column in the query results.

Grouping and Aggregation

Use the Grouping and Aggregation menu choices to specify logical groupings of information within the query results. The following options are available:

• Select No Aggregation to remove any aggregation or summary formation from the selected column.
• Select Top Group to group the selected column without summary information in the top of the query results.
• Select Side Group to group the selected column without summary information to the left side of the query results.
• Select Count to summarize the total number of values in the column.
• Select First to create a summary row showing the first value in the column.
• Select Last to create a summary row showing the last value in the column.
• Select Maximum to create a summary row showing the maximum value in the column.
• Select Minimum to create a summary row showing the minimum value in the column.
• Select Sum to create a summary row showing the sum of the values in the column.
• Select Cumulative Sum to display the values in the column as a cumulative sum, with a summary.
• Select Average to create a summary row showing the average of the values in the column.
• Select Standard Deviation to create a summary row showing the standard deviation of the values in the column.
• Select Percentage of Group to display the values in the column as a percentage value of the group total, with a summary row showing the sum of the percentages.
• Select Percentage of Total to display the values in the column as a percentage value of the column total, with a summary row showing the sum of the percentages.
• Select Cumulative Percentage of Group to display the values in the column as a cumulative percentage value of the group total, with a summary row showing the sum of the percentages.
• Select Cumulative Percentage of Total to display the values in the column as a cumulative percentage value of the column total, with a summary row showing the sum of the percentages.

Show Summaries

Show summary information for the selected Top or Side group column.

Show Total Summaries

Show summary information for the selected total columns.

Drill Down

Expand the Top or Side group detail information.

Drill Up

Collapse the Top or Side group detail information.

Add Calculated Column

Opens the Calculated Columns window enabling you to add a calculated column to the query results. A calculated column is a column of data that is dynamically created based on an expression that you define.

Reset Formatting

Resets the formatting that has been applied to selected columns in the query results to the original formatting attributes.

Reset All

Resets the formatting that has been applied to all the columns in the query results to the original formatting attributes.

AutoFit

Select AutoFit to automatically fit the contents of one of the following:

• Selected Column(s) to automatically fit the contents of the selected columns into the same column size.
• All Columns to automatically fit the contents of all the columns in the query results into the same column size.
• All Rows to automatically fit the contents of all the rows in the query results into the same row size.
• All to automatically fit the contents of the entire query results.

Sort

Opens the Sort window where you can set up multiple levels of sort criteria.

Go to

Opens the Go to Row window, where you can navigate to a specific row.

Find

Initiates a search of the query results for a specific string. You specify the search string using the Find window.

Display Report

Generates visual or classic report using the query results that are active in the editor. You can choose to generate the report based on the existing formatting of the query results or simpler default formatting.

Display Excel Sheet

Opens Microsoft Excel and displays the query results data in an Excel data sheet. (QMF for Workstation only). If you are exporting a query with several result sets, each of the result sets will be displayed in a separate workbook.

Note: For relational query results whose columns have both breaks and usage codes, an Excel PivotTable will be created automatically. Processing time for this functionality increases depending on the amount of data.

Retrieve All LOB Values

Retrieves all LOB values in the query results set.

Export

Opens the Export Query Results wizard where you can choose to save the query results to a file or a database.

Display Chart

Generates a chart from a query result set that is open in the editor.

Filter Results

Opens the Dynamart Filter wizard where you can create filters that control the contents of the query result set. For more information about filtering query result sets, see Filtering query results by using the Dynamart Filter wizard.