1. One View Reporting User Guide
  2. Layout Tab

Layout Tab

The Layout tab enables you to change various run-time options. To access these options, use the Manage Reports selection in the One View menu and then select a report. This is an example of the Layout tab:

Layout tab.

The following table describes the information and options shown in the Layout tab.

Layout Options

Description

Name

The name of a report.

Naming Convention

You can select one of two options when adding a new report:

  • Use Column Title

    For companies with one language preference, end users usually prefer to use column titles when designing reports. If the column title accurately describes the data item, it is more understandable than the data dictionary item name.

  • Use Data Dictionary Item Name

    Developing new reports using data dictionary item names is the preferred method for companies with more than one language preference. Reports that are based on the data dictionary item names are more easily translatable.

Available Layouts

Select a layout from the drop-down list if more than one layout is defined for a report.

Select Row Set

Three row set options are available for the grid data used in a report:

  • Retrieve record count

    The report will display data up to the number of records specified, even if more than the specified number of records match the query conditions. Retrieve record count = 500 is the default unless this value is configured differently for your company. You can override the default setting when you run a report or add a new report.

    NOTE: If the system limit is lower than the value in this field, the data will be limited to the number of records defined by the system limit.

  • Use current data in grid

    The report will display the data currently shown in the grid.

  • Retrieve all records

    The report will display all data matching the current query condition.

If the report data is limited due to this setting, whether by the field value, system limit, or number of grid records, the user running the report will receive the following pop-up warning: "Warning! Report has exceeded the maximum number of records specified. Results shown are incomplete." The user must click OK on this warning in order for the report to appear.

Formats

Depending on the template used for the report, BI Publisher can create output in the following formats:

  • Adobe PDF

  • Microsoft Word (RTF)

  • Interactive Viewer

  • Microsoft Excel 2007

  • CSV

  • Microsoft PowerPoint

  • Microsoft PowerPoint 2007

  • XML