The Page Numbering list box offers several options for page numbering. Select one of the following from the list box:

• Default. Numbers each page of the report in the format PAGE 1, PAGE 2, and so on. The default value is ON.
• ON. Numbers each page of the report in the format PAGE 1, PAGE 2, and so on.
• OFF. Suppresses the display of page numbers.
• NOLEAD. Suppresses the two leading blank lines included on each page by default.

To limit the number of records retrieved when reporting from a non-FOCUS data source, enter a number greater than zero in the Read Limit box. A read limit specification is ignored when reporting from a FOCUS data source.

To limit the number of records retrieved when reporting from a FOCUS data source, enter a number greater than zero in the Record Limit box.

These options are for development only.

Note:

• A warning is issued to indicate to the user that the report they are viewing is only a subset of the actual data. This occurs when either Record limits or Read limits are checked in the Properties tab, under Warning message displayed in Heading.
• The This report is only a subset of the data edit box is checked by default. You can deselect the check box for this message or design a new message. Either message will appear in the heading of the report.

You can specify a report title in the Report Title field that will appear in the title bar of your report. This option is not available for reports generated in PDF or PS format or for reports that utilize on-demand paging.

You can specify summary text for your report in the Summary Text for Report field. This will place a description of the output into a SUMMARY object inside the output HTML TABLE. The length limit of this summary is 500 characters. If you try to set the SUMMARY to more than 500 characters, you receive the following message:

Limit on length of summary is 500 characters.

Note: You can only specify summary text when the Use Accessibility features (Section 508) option is checked.

To style the entire report:

Note: Clicking Reset returns the styling options to the following default settings:

• Font: Times New Roman
• Style: Normal
• Size: 13
• Text Color: Black
• Background Color: Transparent
• Justification: Left

When you select PDF or PostScript (PS) as the display format for a report, WebFOCUS offers several additional styling features.

The following procedure describes how to justify an entire report. This affects headers, footers, fields, and field headings.

When you check Optimize output with Cascading Style Sheets in the Report options tab of Report Assistant, your report will reflect the styling options you select, and generate Internal Cascading Style Sheet code in the HEAD tag of HTML reports. This feature is available only if you select HTML in the Generate report as drop-down list.

OLAP options are available in the Interactive options section of the Report options tab in Report Assistant. The relevant options—Enable OLAP and Automatic Drill Down—are located here.

Enable OLAP Options

The Enable OLAP options in the Report Assistant control how users can interact with an OLAP report and access OLAP tools.

For Standard Reports delivered to Managed Reporting users, these decisions are made by Managed Reporting Developers. However, users who are creating their own reports can OLAP-enable them and control the following OLAP interfaces and drill down options.

• OFF. OLAP is off when off is selected, OLAP options are not available for the report.
• Columns only. Turns off the OLAP Control Panel and the OLAP Selections pane, but enables OLAP functionality from the report itself. You can access options on right-click menus, drag and drop columns within the report, and use up and down arrows to sort columns from high to low or vice versa. This is the default.
• Columns with panel. Provides access to the OLAP Selections pane from a square button to the left of the column titles.
• Show filters on top. Opens the OLAP Selections pane above the report. The Measures, Graph, and Dimension controls, as well as the band containing the OLAP, Run, and Reset buttons appear above the report output. You can open the Control Panel by clicking the OLAP button on the Selection pane.
• Show filters on bottom. Opens the OLAP Selections pane below the report. The Measures, Graph, and Dimension controls, as well as the band containing the OLAP, Run, and Reset buttons appear below the report output. You can open the Control Panel by clicking the OLAP button on the Selection pane.
• Show Panel in Report. Opens the OLAP report with the OLAP Selections pane hidden. You can perform a variety of analytic tasks from the report itself. Selection Criteria is shown next to the OLAP button.
• Show Tabbed. For OLAP reports that have multiple dimensions, this option groups the dimension elements under a tab labeled with the dimension name.

Automatic Drill Down Options

These options enable you to sort instantly from high to low or low to high for selected report columns:

• Off. Disables automatic drill downs.
• Dimensions only. Enables automatic drill downs on dimensions in reports and graphs.
• Measures and Dimensions. Enables automatic drill downs on dimensions in both reports and graphs and on measures in reports.

You can have pop-up field descriptions display in an HTML report when the mouse pointer is positioned over column titles. Field description text displays in a pop-up box near the column title using the default font for the report. Pop-up text appears for report column titles including titles created with ACROSS phrases and stacked column titles created with OVER phrases.

The pop-up text displayed for a column title is defined by the Description attribute in the Master File for the corresponding field. If a column title has no Description entry in the Master File, then no pop-up box is generated when your mouse is positioned over the title.

This feature is not supported in the HTML Graph Assistant.