In this section: |
The Field tab appears in the ribbon when you select a data source field in the Query Design pane or Layout canvas. The options available in the Field tab are specific to the data type that is selected. The options available for numeric fields are different from the options available for non-numeric and date fields. The Field tab provides access to the Filter, Sort, Break, Style, Format, Display, and Links groups. It is shown in the following image.
The Field tab provides the following groups and options.
The Filter group contains the following filtering options:
The Values drop-down menu contains the following options:
The Prompt drop-down menu contains the following options:
Selecting any Prompt option changes the purpose of the dialog box to creating an auto prompting parameter that you can select when you run a report. When you select the Prompt using Data Values (Dynamic) option or the Prompt using Text Input (Simple) option, the Values drop-down menu is unavailable. The Filter dialog box is shown in the following image.
When you select an existing filter in the Filter area of the Query Design pane, choosing Exclude removes, but does not delete, the filter from the report. When you select a filter that was previously excluded from a report in the Filter area of the Query Design pane, choosing Include restores the filter to the report.
The following is an example of a dialog box that prompts the user for a parameter value. This dialog box opens when you run a report after creating a dynamic auto prompting parameter for the Product field.
If you click the Allow Multiple Values for Prompt button while creating a dynamic auto prompting parameter, a multi-select menu appears when the report is run. Selecting multiple parameter values displays the output in the same dialog box as the prompt, as shown in the following image.
The Sort group contains the following sorting options:
For more information about these report options, see Using Custom Reporting Features.
The Break group contains the following options for customizing a report:
For more information about these report options, see Using Custom Reporting Features.
The Style group contains styling options for reports and charts. For a selected field in a report, you can customize the font type, font size, font color, background color, and restore styling to the default values. You can also style fonts (bold, italic, underline), justify text (left, center, right). You can apply styling to the Data (default), column Title, or both the Data and column Title for the selected field in a report.
For more information about styling reports, see Styling Reports.
The Format group contains the following formatting options for virtual or column fields:
The drop-down menu provides three field-type options for the selected column, which are Alphanumeric, Integer, and Decimal. Selecting the fourth option, More options, opens the Field Format Options dialog box, which provides further formatting options for the selected field. For more information, see Changing a Field Format.
You can also apply floating and non-floating currency, percent signs, and commas. You can increase and decrease decimal places by clicking the appropriate buttons under the drop-down menu.
The Currency button is a split button that turns the currency symbol on or off. Click the Currency button to turn on the default floating currency option. Click the Currency button a second time to turn off the floating currency option.
To turn on the non-floating currency option, open the drop-down menu and select Non floating currency. To turn off the non-floating currency option, click the Currency button.
The Display group contains the following additional options for a selected field:
Sum is the default aggregation type value for all numeric fields added to the Measure field container in the Query Design pane. Changing the Measure field container from Sum to Print, Count, or List overrides all assigned aggregation type values. For more information related to reports, see How to Display Numeric Measure Data Using Aggregation Options in a Report. For more information related to charts, see How to Display Aggregations on Measures.
For more information related to reports, see Styling Reports. For more information related to charts, see Traffic Light Condition Dialog Box.
The Links group contains the Hyperlink command to add a hyperlink or drill-down procedure to a selected field in a report.
Click Hyperlink to open the Drill Down dialog box, shown in the following image. In the Drill Down dialog box, you can configure a hyperlink or a drill-down procedure for the selected field. Clicking that field in report output takes you to the specified URL or executes the specified procedure.
WebFOCUS |