Appearance Tab

In this section:

You use the Appearance tab while creating or editing a report to filter specific fields, sort data in a field, and style the titles and data of a field. The Appearance tab is located at the top of the App Studio interface. It is only accessible when a field is selected on the Report canvas. The Appearance tab is shown in the following image.

Appearance tab


Top of page

x
Style Group

You can the style data, titles, and text of a selected field. The Style group is shown in the following image.

Style group

The commands are:

Scope

Indicates whether style options apply to the data, title, or both.

Bold

Applies bold font formatting to the text or selected object.

Italic

Applies italic font formatting to the text or selected object.

Underline

Underlines the text or selected object.

Left

Aligns the text or selected object to the left.

Center

Aligns the text or selected object to the center.

Right

Aligns the text or selected object to the right.

Default

Applies the default alignment options. In this case, numerals are aligned to the left and text is aligned to the right.

Column Width

Sets column width options.

Copy Style

Copies the style of the selected object, enabling the Paste Style command.

Paste Style

Pastes your copied style settings to the selected field.

Match Style

Copies the specific style settings from one column to another.

Font Name

Changes typed or highlighted text to the selected font.

Font Size

Changes typed text or a selected object to the selected size.

Color

Changes typed text or a selected object to the selected color.

Background Color

Changes the background color. Opens the Color dialog box, where you can select the background color.

Defaults

Resets the typed text or a selected object to the default style settings.

Borders

Turns borders and gridlines on or off.

Related Information:


Top of page

x
Format Group

Use the tools in the Format group to change the formatting of numeric detail fields. For example, you can add percentage signs to data and indicate currency (with or without symbols). This group is unavailable when the format option or edit option for the selected field are eight characters in length or attempt to go over eight characters in length.

Note: If you select Sort Down, Sort Across, or For Row, the options in the Format group will be unavailable.

The Format group is shown in the following image.

Format group

The commands are:

Currency

Adds a currency symbol in front of the field data. Enables the selection of a currency, for example Floating Dollar or Fixed Euro. The symbol used is that of the currency selected. If a Fixed currency is selected, no symbol appears. If a Floating currency is selected, the currency symbol appears.

Percent

Adds a percentage symbol after the field data.

Comma

Enables the display of commas in the field data.

More Decimals

Decreases the number of decimal positions shown.

Less Decimals

Increases the number of decimal positions shown.


Top of page

x
Display Group

In this section:

You can add a data visualization column to a report, display numeric data differently, and add conditional styling. The Specific group is shown in the following image.

Specific group

The commands are:

Data Bars

Enable the Data Visualization dialog box, through which you can add a data visualization column to the right of a selected numeric field. The column displays values in each row using horizontal bars that extend from left to right in varying lengths, depending on the corresponding data values. For more information, see Data Visualization Dialog Box.

Aggregation

Displays numeric data using a variety of aggregation types. Different aggregation types are available depending on the field and the column type for that field. These aggregation types are:

  • (None)
  • Sum
  • Average
  • Count
  • Count Distinct
  • Percent of Count
  • Distinct Values
  • First Value
  • Last Value
  • Minimum
  • Maximum
  • Total
  • Percent
  • Row Percent
  • Median
  • Mode
  • Average Square
Traffic Lights

You use the Traffic Lights functionality to set styling and hyperlinks conditions. Adds conditional styling or modifies existing conditional styling by applying colors to a field in the output when the field meets specified criteria. Options include: None or Add/Edit Conditions. If you select Add/Edit Conditions, the selection option changes to Sorted Data.

To style a specific condition, select a condition and then use the Style group. This will only style the condition you selected.

Hide Field

You can hide or show a selected field in the output. Fields added to a report or chart are visible in the output by default. The Visibility group is shown in the following image. Options include On, Off, or Variable. When a data field is invisible, it appears on the Report canvas (dimmed) and is not visible in the report output.

Note: An invisible column or field may be used in the report as part of a calculation, even though it is set to invisible and will not display in the output.



x
Data Visualization Dialog Box

You use the Data Visualization dialog box to define the data visualization bar graphs that appear in your report.

If you are setting conditions to control the display of bar graphs, you use the Data Visualization Conditional Styling dialog box instead of this one.

The Data Visualization dialog box contains the following fields or options:

Visualize

Initiates the Data Visualization feature.

Color

Specifies the color of the bar graphs. Select a color from the drop-down list. Black is used as the default color.

The color option is the default for HTML, PDF, and PS formats.

Pattern

Specifies the shading patterns for bar graphs. Select a shading pattern from the drop-down list.

This option is only available for PDF and PS formats to make graphs in black and white reports more readable. If the report format is HTML, the Pattern option button is inactive because the shading option is only available for PDF and PS formats.

Graphlook

Specifies how the graph looks. Select a look from the drop-down list.

Note: Graphlook Gauge or Quality do not support negative values. Use Bar Graphs instead.

Scale

Specifies the relative bar graph scaling for multiple report columns under a common Across sort field to which you have applied data visualization.

Note: This option only appears when applied to the entire report.

Choose one of the following options from the Scale drop-down list:

Uniform

Specifies that each vertical bar graph be scaled based on the minimum and maximum values of the entire set of values compiled from each Across column to which you have applied data visualization bar graphs.

Distinct

Specifies that each vertical bar graph be scaled based on the distinct minimum and maximum values for each Across column to which you have applied data visualization bar graphs.

Maximum Length:

Specifies the length of the longest bar graph.

Default. The default length of 60 pixels is used for a vertical bar graph and 80 pixels for a horizontal bar graph.

Custom. Sets the value for displaying the vertical or horizontal bar graph for the maximum data value in the associated report column. This value must be a positive number.

This value is initially expressed in the current windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.

Width:

Specifies the width of the bar graphs in a report.

Default. This value is preset based on the current font size.

Custom. Sets the value for displaying the width of the bar graphs in a report. This value must be a positive number.

This value is initially expressed in the current windows measurement units (inches, centimeters), then converted into the corresponding number of pixels.

Default Values button

Resets all defaults.

Conditional Styling button

Opens the Data Visualization Conditional Styling dialog box where you can define conditions and colors for bar graphs.


Top of page

x
Links Group

How to:

You can add a hyperlink or drill-down procedure to a selected field in a report. The Links group is shown in the following image.

Links group

The command is:

Hyperlink

Adds a hyperlink or drill-down procedure to a selected field in a report. For more information, see How to Access the Drill Down Dialog Box.



x
Procedure: How to Access the Drill Down Dialog Box
  1. On the Report tab, in the Links group, select Hyperlink.

    The Drill Down dialog box displays.

  2. Select one of the following actions:
    • No action (default)
    • Execute Procedure (FOCEXEC)
    • URL
    • URL from field
    • Javascript
    • Maintain Case
    • Maintain Procedure
    • Maintain Procedure Compiled

    Note: If you select an action involving a procedure, the Browse button will be enabled, allowing you to navigate to the location of the procedure.

  3. Select a Target Frame using the drop-down list box.

    Note: This does not display when URL from field is selected.

  4. Click Add.

    The Drill Down Parameter dialog box displays.

  5. Select a Parameter name from the drop-down list box.
  6. For Parameter value, select one of the following options:
    • Field. Allows you to select a specific field from the drop-down list.
    • Constant Value. Allows you to specify a constant value.
    • Variable. Allows you to specify a variable.
  7. Click OK.
  8. On the Drill Down dialog box, click OK.

Top of page

x
Active Technologies Reports Group

You can choose to show or hide columns in an active report, as shown in the following image.

active reports group

Present Hidden

You can select which columns are hidden from view, in the report output, when using the HTML active report output format.


WebFOCUS