Features Added in FOCUS 7.7.03

To control how windows display in the report output when multiple windows are open in the Web browser, use

TYPE=REPORT, WINDOW-DISPLAY=wdisplay, $

where:

wdisplay

Enables the report to display multiple open windows as tabs or cascaded windows in the Web browser. Multiple windows are created in the browser when viewing data as a chart, a roll-up table, and so on.

Valid values are CASCADE or TAB.

To control the colors of the row being selected or hovered over, use

To control the user menu options, which determine the location and color characteristics of the user menu in the report, use the appropriate syntax section that follows.

To control all of the colors of the user menu, use

TYPE=REPORT, OBJECT=MENU, COLOR=textcolor, 
HOVER-COLOR=hovertextcolor, BACKCOLOR=backcolor, 
HOVER-BACKCOLOR=hoverbackcolor, BORDER-COLOR=bordercolor, $

where:

MENU

Specifies the object, which is the user menu.

textcolor

Specifies the color of the text (font) in the user menu. BLACK is the default value. Valid values can be either a preset color name in single quotes, for example, 'YELLOW', or the RGB (red green blue) numeric values, for example, RGB(153 153 153).

hovertextcolor

Specifies the color for the hover text in the user menu. BLACK is the default value. Valid values can be either a preset color name in single quotes, for example, 'RED', or the RGB (red green blue) numeric values, for example, RGB(255 255 153).

backcolor

Specifies the color for the background (non-text) areas in the user menu. SILVER is the default value. Valid values can be either a preset color name in single quotes, for example, 'GOLD', or the RGB (red green blue) numeric values, for example, RGB(153 51 0).

hoverbackcolor

Specifies the color for the background area of the user menu where your mouse pointer is hovering. WHITE is the default value. Valid values can be either a preset color name in single quotes, for example, 'ORANGE', or the RGB (red green blue) numeric values, for example, RGB(51 204 204).

You can use this, along with the hover text color, to visually contrast the menu option where the mouse is currently hovering from the rest of the menu.

bordercolor

Specifies the color for the borders of the user menu. WHITE is the default value. Valid values can be either a preset color name in single quotes, for example, 'BLUE', or the RGB (red green blue) numeric values, for example, RGB(255 255 153).

To control the calculations options, which determine the column and the calculation you want to perform, along with the styling characteristics of the calculation results row, use the appropriate syntax section that follows.

• To perform column calculations, use

  TYPE=REPORT, COLUMN=coldesc, CALCULATION=calc, $

  where:

  coldesc

  Specifies the description (column name or identifier) of the column where you want to perform a calculation.

  calc

  Specifies the calculation to be performed. The default is no calculation.

  For columns containing numeric data, select from: SUM, AVE, MIN, MAX, CNT, CNT.DST, PCT.TOT

  PCT.TOT values appear in a separate column adjacent to the column for which it is calculated, and styling is inherited from the visualization column.

  For columns containing text (alphanumeric) data, select from: CNT, CNT.DST

• To control the location of the calculation results row, use

  TYPE=REPORT, CALC-LOCATION={TOP|BOTTOM}, $

  where:

  TOP

  Specifies the top row of the report as the location of the calculation results. TOP is the default value.

  BOTTOM

  Specifies the bottom row of the report as the location of the calculation results.

• To control the colors of the calculation results row, use

  TYPE=REPORT, OBJECT=CALC-AREA, COLOR=color, BACKCOLOR=backcolor, $

  where:

  CALC-AREA

  Specifies the object, which is the calculation results row.

  color

  Specifies the color for the calculation values in the calculation results row. The default value is BLACK and is inherited from the column title font color. Valid values can be either a preset color name in single quotes, for example, 'RED', or the RGB (red green blue) numeric values, for example, RGB(255 255 153).

  backcolor

  Specifies the color for the background in the calculation results row. The default value is WHITE and is inherited from the column title background color. Valid values can be either a preset color name in single quotes, for example, 'GOLD', or the RGB (red green blue) numeric values, for example, RGB(153 51 0).

To control the colors of the graphic values used with the visualization option, use

To control the freeze column options, which determine the column (and all columns to the left) that will freeze when scrolling to the right to view other columns in the report output, use

or

TYPE=REPORT, FREEZE-WIDTH=AUTO, $

where:

coldesc

Specifies the description (column name or identifier) of the column you want to freeze. You can only specify one freeze column, which must be a BY sort field. The default value is none (no freeze column).

AUTO

Enables the report to freeze at a particular column that will be automatically determined by FOCUS for optimal viewing.

If you can view the entire report output on the screen without scrolling, the freeze will not be applied.

To control the hide columns options, which determine the columns that will be hidden from view in the report output, repeat the following for each column you want to hide.

To control active report menu options available to the users, use

Use the appropriate syntax section that follows.

• To control the number of rows displayed per page in the output, use

  TYPE=REPORT, LINES-PER-PAGE={n|UNLIMITED},$

  where:

  n

  Specifies the number of rows displayed on each HTML page. The default value is 20 rows when the LINES-PER-PAGE option is used. Otherwise, the FOCUS default value is 57 rows.

  UNLIMITED

  Specifies that you want to show all the results on one HTML page.

• To control the position, justification, and colors of the record status and page navigation bar, use

  TYPE=REPORT, OBJECT=STATUS-AREA,PAGE-LOCATION={TOP|BOTTOM},JUSTIFY={LEFT|CENTER|RIGHT},
  COLOR=textcolor, BACKCOLOR=backcolor,$

  where:

  STATUS-AREA

  Specifies the object, which is the record status and page navigation bar.

  The record status and page navigation bar show row and page information, where your cursor is positioned, relative to the total number of rows and pages in the report (for example, 10 of 100 records (10.00%), Page 1 of 3).

  PAGE-LOCATION

  Specifies the location of the record status and page navigation bar, which is either at the top of the report above the report header, or at the bottom of the report below the report footer. TOP is the default value.

  JUSTIFY

  Specifies whether you want the information in the record status and page navigation bar to be centered, left-justified, or right-justified. CENTER is the default value.

  textcolor

  Specifies the text color for the record status and page navigation bar. BLACK is the default value. Valid values can be either a pre-set color name in single quotes, for example, 'GREEN', or the RGB (red green blue) numeric values, for example, RGB(153 153 153).

  backcolor

  Specifies the background color for the record status and page navigation bar. SILVER is the default value. Valid values can be either a pre-set color name in single quotes, for example, 'WHITE', or the RGB (red green blue) numeric values, for example, RGB(51 153 102).

The following apply when filtering data:

• Filtering data in the Scientific Notation format is not supported.
• Applying a filter to an active report with a calculation applied to a numeric column correctly displays the filtered percentage. The filtered percentage does not appear for non-numeric columns.

• If no records are returned after applying a filter, the Status Bar states Page 1 of 1 and, for example, 0 of 10 records.

The following apply when selecting values to be filtered:

• If there are less than 20 unique values in the matching records to be filtered, they will be displayed in a drop-down list, as shown in the following image.

  You may not type input values in the filter field.

  
• If there are more than 20 and less than 1,000 unique values, the value selection dialog box appears, as described in How to Filter Selections Using Multiple Values.

  You may not type input values in the filter field.

  
• If there are more than 1,000 unique values, there is no value selection dialog box or filter value drop-down list. Manually type the input value in the filter value field.
  

In addition to using column controls to filter and highlight your report, you may also filter, highlight, and comment individual rows of data in the active report output.

When a row is selected, the context menu offers options to add comments, highlight values and rows, and filter cells.

For example, the image below shows the context menu for a row in the active report output.

The following apply to charts.

• X-axis labels overlap and are cut off when you reduce the size of a chart.
• If there are multiple Y-axis fields for a pie chart, the chart uses the first field selected to draw the chart. If adding multiple Y-axis fields to draw the pie chart from the chart window, the chart uses the first Y-axis field selected to draw the pie chart.
• Scatter charts can represent only detailed data (numeric) without any aggregation method applied.
• When you create a pie chart using the HTML active report output format (AHTML), the values are sorted alphabetically in the pie slices clockwise, from left to right. When you create a pie chart using the active report for Adobe Flash Player (FLEX) and active report for PDF (APDF) output formats, the values are sorted alphabetically in the pie slices counter-clockwise, from right to left.

The following apply when you use the Grid Tool in active reports:

• The same column can appear in both the Column Order and Sort Order section.
• Column Order displays the order of how columns appear in the report, unless Group sort columns is selected. The Sort Order list overrides the Column Order if Group sort columns is selected.
• The Column Order and Sort Order sections can contain field names in a different order, as long as Group sort columns is not selected.
• Columns can be dragged from Column Order to Sort Order but they cannot be dragged from Sort Order to Column Order.
• Sort ascending is the default sort order, when columns are added to the Sort Order section.
• There are no calculations set by default. Sum, Avg, Min, Max, Count, or Distinct are available for numeric fields. Min, Max, Count, or Distinct are available for Date type fields. Count or Distinct are available for non-numeric alpha string fields. None indicates that there will be no aggregation performed or applied for the column in the report.
• When the Subtotal option is selected and an aggregation type is selected in the Column Order, subtotals display by the corresponding sort field (for the fields that have calculations specified).
• Total plus the aggregation type (Cnt, Sum, and so on) appears with the column in the report output when Subtotal is selected.
• You may not add additional columns to Sort Order once Group sort columns is selected. Deselect Group sort columns to add additional columns.
• If a column is hidden and appears in the Sort Order section, the subtotal value will also be hidden if Group sort columns is selected.
• When a filter is applied to the report, the subtotal will display the filtered value.
• Subtotals are not supported with date fields.
• The active report Sort Ascending and Sort Descending menus will override the options set in the Sort Order section of the Grid Tool.
• The subtotal background color and font color can be changed by using CALC-AREA object in the STYLE section of the procedure. For example:

  TYPE=REPORT,OBJECT=CALC-AREA,COLOR=WHITE,BACKCOLOR=BLACK,$

• The font style for the subtotal values can be changed by using TITLE type in the STYLE section of the procedure. For example:

  TYPE=TITLE,FONT='GEORGIA',COLOR=RGB(78 137 187),$

The following apply when you use the Chart/Rollup Tool in active reports:

• The Group By and Measure sort fields are required.
• You may use multiple Group By and Measure sort fields. Group By is the column(s) used for the X-axis and Measure is the column(s) used for the Y-axis.
• You may only use one Measure sort field (as the Y-axis) when using a Pie chart.
• The same column can appear in both the Group By and Measure sort field.
• Columns can be dragged between the Group By and Measure sections but they cannot be dragged back to the Columns section.
• The Measure sort field displays Sum for numeric fields and Count for non-numeric fields by default.
• Headings for the chart are generated using the field name, or column title name. The report HEADING is inherited only if REPORT-VIEW=CHART is set in the procedure.
• When you use the Chart/Rollup Tool with hidden fields (HIDE=ON StyleSheet setting), the hidden columns will not be displayed in the Rollup Table. To display the hidden columns in the Rollup Table, select Show Columns from the active report menu, and select the column name you want to display.

The following apply when you use the Pivot Tool in active reports:

• The Group By and Measure sort fields are required.
• You may not use multiple Measures.
• The same column cannot appear in both the Group By and Across sort field.
• Columns can be dragged between the Group By, Across, and Measure sections but they cannot be dragged back to the Columns section.
• If a column already exists in the Measure sort field, an additional column that is dropped into Measures section will replace the existing column.
• The Measure sort field displays Sum for numeric fields and Count for non-numeric fields by default.