Displays the individual values of the selected fields when the report is executed. This button is selected by default when you open Report Painter.

Provides a total of all values for the selected numeric field when the report is executed.

Vertically sorts and groups data in a report by the values in the selected field. You can sort a report by more than one field.

Sorts and formats a hierarchy with appropriate indentations that clearly show the parent and child relationships in a hierarchy. You can have multiple hierarchy sort fields in a report.

Note: This option is only available when using a multi-dimensional data source. For more information, see Sorting Hierarchical Data in the Creating Reporting Applications With Developer Studio manual.

Horizontally sorts and groups data in a report by the values in the selected field. You can sort a report by more than one field.

Enables you to structure financial reports row-by-row in the Financial Report Painter, based on the selected For field. , see the Creating Financial Reports manual.

Allows you to select Where, If, Where Total, and Retrieval Limits. If Where, If, or Where Total is selected, the Expression Builder opens. If Retrieval Limits is selected, the Retrieval Limits dialog box opens.

Opens the Forecast dialog box in which you can add a Forecast column to the report. This feature calculates trends in numeric data and predicts values beyond the range of values stored in the data source.

For details about creating temporary fields in reports, see Calculating Trends and Predicting Values With Forecast .

Used with Guided Reports. Generates a parameter group from the selected column or columns.

Enables you to select a guided report variable mode.

• One variable for each selected column. Creates one control for every selected column with all the selected field names as values.
• One variable for all selected columns. Creates one control for all selected columns with all the selected field names as values.

Removes a column or columns from the parameter group. The columns selected must be part of a parameter group to use this button.

Enables you to enter a report heading for the report. A report heading is text that appears above the page heading at the top of the first page in a report.

Enables you to enter a page heading in the report. A page heading is text that appears at the top of every page in a report.

Enables you to enter a page footing in the report. A page footing is text that appears at the bottom of every page in a report.

Enables you to enter a report footing for the report. A report footing is text that appears below the page footing at the bottom of the last page in a report.

Enables you to enter a subheading in the report. The subheading appears each time the selected sort (By) field changes. It is placed before the new value.

Displays a subtotal for numeric data whenever the value of the selected sort (By) field changes.

Displays a total to all numeric columns and rows in the Report Painter window. If a column or row total already exists, clicking Total adds the total type that is missing. If both a column and row total already exist, the Totals option is unavailable.

Enables you to enter a subfooting in the report. The subfooting appears each time the selected sort (By) field changes. It is placed after the new value.

Enables you to select a styled report format from the Output Format drop-down list.

Note: For other available report formats, open the Report Options dialog box and select the desired output format. If you are opening a report that was created using the Document Composer tool, the output format cannot be changed.

Opens the Report Options dialog box, from which you can change the properties of your report, apply formatting, add images, calculate values, apply selection criteria, and so on.

Specifies the size (magnification or scale) of the Report Painter window. Options are 100%, 75%, 50%, or 25%. The default value is 100%.

Saves the entire report procedure to disk.

Executes the report.

Removes the selected item and places it on the clipboard.

Copies the selected item to the clipboard.

Inserts the content of the clipboard at the insertion point or replaces a selected item.

Deletes the selected item from the report.

Undoes the last command or action. This restores the report to the properties that existed prior to the last command or action.

If the last command or action was undone (using the Undo button), this performs the last command or action again.

Toggles between displaying or hiding invisible fields in the body of the report.

Toggles between displaying or hiding the Object Inspector.

Converts the report to a Precision report. For more information, see Creating Precision Reports.

Promotes the report to a Compound Document. The original report remains unchanged while a copy of that report is placed on the Document canvas, in the Document Composer. For more information see the Creating Compound Reports With Document Composer manual.

Applies styling only to the title component of the column.

Applies styling only to the data component of the column.

Applies styling to the entire column, both title and data.

Changes the font type of the selected item.

Changes the font size of the selected item.

Increases the font size of the column object by one point.

Decreases the font size of the column object by one point.

Applies the bold style to the selected object.

Applies the italic style to the selected object.

Applies the underline style to the selected object.

Applies the WebFOCUS language underline command to the selected object.

Applies left justification to the selected object.

Applies center justification to the selected object.

Applies right justification to the selected object.

Returns the default justification to the selected object.

Enables you to change font color.

The Match All Styles button has a drop-down list with options that are primarily used to copy format characteristics from one column and apply the characteristics to another column. To activate the button, you must multi-select two or more columns. When you click one of the options from the drop-down list, Report Painter copies the style from the first column selected and applies the style to all other selected columns. Depending upon your selection, certain toolbar buttons may be inactive or unavailable. The styling options are: Match All Styles, Match Font, Match Grid/Border, Match Background Color, Match Conditional Styling, Match Justification, Match Width Attributes.

Opens the StyleSheet Selection dialog box, which enables you to reference or embed an external StyleSheet, use the default WebFOCUS StyleSheet, or apply no styling to your report. For more information, see Using the StyleSheet File Selector.

Launches the Define tool. The Define tool enables you to create a virtual field as a component in a reporting procedure. A virtual field is evaluated on each retrieved record that passes any selection criteria on the real fields. Define the virtual field by assigning a format and typing an expression or composing it using the calculator and the fields and functions listed in the tabbed panes in the Define tool window. The result of the expression is treated as though it were a real field stored in the data source.

For details about creating temporary fields in reports, see Creating Temporary Fields in the Creating Reporting Applications With Developer Studio manual.

Opens the Report Options dialog box at the Computes tab, enabling you to create a calculated value. For more information, see Creating Temporary Fields With Report Painter.

Launches the Join tool. If a report requires data from two or more related data sources, you can temporarily join the files and report from them as if they were one. Joined files remain physically separate, but are treated as one data source structure.

The Join tool provides a graphical method for creating and manipulating all types of Joins. You must specify a host file, then a cross-referenced file to create a join.

Note: Joins are not supported for cube data sources and therefore, the Join icon is unavailable.

For instructions on creating joins, see Joining and Merging Data Sources in the Creating Reporting Applications With Developer Studio manual.

Opens the Universal Concatenation dialog box, enabling you to retrieve data from unlike data sources in a single request. For more information, see Universal Concatenation in Report Painter.

Launches the Dimension Builder tool. The Dimension Builder tool allows you to create a temporary OLAP hierarchy and dimensions. Unlike the Synonym Editor, this tool does not modify the Master File.

For instructions on creating dimensions, see Analyzing Data in an OLAP Report in the Online Analytical Processing (OLAP) manual.

Launches the Set tool. The Set tool enables you to customize procedure development. It controls the way that reports and graphs appear on the screen or printer, the content of reports and graphs, data retrieval characteristics that affect performance, and system responses to user requests. It also helps you set up your metadata and manipulate information, such as dates.

For a list of SET commands, see Customizing Your Environment in the Developing Reporting Applications manual.