Report Options Tab

Reference:

The Report options tab is used to select options for a report.


Top of page

x
Reference: Report Options Dialog Box

The following image shows the Report options tab where you select report output formats.

Generate report as list box (when check box is selected)

When the Show styled formats check box is selected, choose from the following formats:

  • HTML - Web browser
  • HTML - Web browser (with grid)
  • AHTML - active report
  • FLEX - active report Flash
  • PDF - Portable Document Format
  • EXL97 - Excel 97
  • EXL07 - Excel 2007
  • EXL2K - Excel 2000
  • EXL2KFORMULA - Excel 2000 with FORMULA
  • PS - Postscript
  • User
Generate report as list box (when check box is not selected)

When the Show styled formats check box is not selected, choose from the following formats:

  • EXCEL 95 - Excel 95
  • DOC - Plain text with page breaks
  • WP - Plain text without page breaks
  • WK1 - Import to Lotus 1-2-3. See Notes on Using Lotus Format.
  • DIF - Import to spreadsheet
  • LOTUS - Import to Lotus 1-2-3. See Notes on Using Lotus Format.
  • TABT - Tab-delimited
  • XML - eXtensible Markup Language
Show styled formats check box
x

Check to show output formats that support styling options.

x x x

The Output format specific section has these options:

Report title

Enter the report title in the text box.

Optimize output with Cascading Style Sheets

Check to optimize output with Cascading Style Sheets.

x
Use accessibility features (Section 508)

Check to use accessibility features (Section 508).

Summary text for report

Add summary text in the text box. See How to Include Summary Text for a Report.

The Interactive options subsection has these options: x

Enable OLAP

Choose:

  • OFF
  • Columns only
  • Columns with panel
  • Show filters on top
  • Show filters on bottom
  • Show panel in report
  • Show Tabbed
x
Automatic drill down

Choose:

  • Off
  • Dimensions only
  • Dimensions and Measures
x
On-demand paging

Check to initiate on-demand paging.

x
Show pop-up field description

Check to display pop-up field descriptions for column titles. See Displaying Pop-up Field Descriptions for Column Titles.

The Global report styling section has these options: x

Font and Settings button

Opens the Styles dialog box.

Font

Select from the list box.

Style

Select from normal or bold, italic, underline, and various combinations.

Size

Select a font size from the list box.

Text color

Select a color from the color palette.

Background color

Select a color from the color palette.

Justification

Select left, right, or center from the list box.

Currency Symbol

Select a different currency symbol to override the currency symbol set on the reporting server. Choose from Default, USD, GBP, JPY, EUR, $, or Custom in the Currency Symbol menu. When you select Custom, replace “Custom” with the desired one-character custom currency symbol in the Currency Symbol field.

Display all sort values

Select the Display all sort values check box to display repeated sort values. Use this option to prevent discontinuous data in a report and display repeated sort values. This is recommended for use with Excel Named Ranges.

Active Technologies Report Styling

Opens the active report styling dialog box. This button is only active when you select the AHTML - active report output format. See Creating an Active Technologies Report.

x
Apply an existing WebFOCUS Style Sheet

Select None or a Style Sheet from the list box.

x
Apply an existing Cascading Style Sheet

Select None or a Style Sheet from the list box.

The Content and generation section has these options: x

Page numbering

Select Default, On, Off, or NOLEAD from the list box.

  • Default. Numbers each page of the report in the format PAGE 1, PAGE 2, and so on in the upper left-hand corner of the page.
  • On. Numbers each page of the report in the format PAGE 1, PAGE 2, and so on in the upper left-hand corner of the page. On is the default value.
  • Off. Suppresses the display of page numbers.
  • NOLEAD. Suppresses the two leading blank lines included on each page by default, causing the report to be printed as a continuous logical page. When PAGE is set to NOLEAD, the maximum number of lines that appear on a logical page, from the heading at the top to the footing on the bottom is 57.
Limit the number of read operations performed during report generation

Enter a number in the text box.

Stop retrieving reports after the specified number have been included in the report

Enter a number in the text box.


Top of page

x
Reference: Notes on Using Lotus Format

The Display Format selection box on the Report options tab lists Lotus as a display format. This format, however, does not create a valid Lotus™ spreadsheet. To work around this limitation, follow these steps:

  1. Select the Excel display format.
  2. When the request is run, WebFOCUS prompts you to save or open the file, select Save.
  3. Save the file with an .xls extension to a valid directory.

    Lotus Release 5.0 or higher can open files with an .xls extension.


WebFOCUS