Reporting Tab

In this section:

The Reporting tab contains the following options:

Format Output for...

Screen

Select Screen to format reports for the screen.

Printer

Select Printer to format reports for the printer.

The following options affect the display of the Fields window:

Field List Options

Description

Sort the list by field name

Sorts any list of field names alphabetically.

Show fully qualified field names

Displays any list of field names as qualified field names, which includes data source and table names, alphabetically.

Display the field name

Displays the full field name in the Fields window, as specified in the file description.

Display the field alias

Displays the alternate field name in the Fields window, as specified in the file description.

Display field titles

Displays the column title in the Fields window, as specified in the file description.

Display field descriptions

Displays descriptive information about the field in the Fields window, as specified in the file description.

Display the data formats

Displays the field length and format type in the Fields window, as specified in the file description.

Expand field tree

Displays fields in expanded mode when using a Field Tree. If this option is not selected, segments appear collapsed wherever a Field Tree appears.

Note: This option can also be accessed from the Field Tree context menu.

Display Filters in Filters Folder

Displays filters in a separate Filters folder of the Field Tree. If this option is not selected, filters appear with the rest of the fields in the segment.

Note: This option can also be accessed from the Field Tree context menu.

Style Sheet Merge Options

Option

Description

Drilldowns

Preserves drilldowns in your current StyleSheet when you apply another StyleSheet to a report.

Authoring Mode

The Authoring Mode options determine how fieldnames in a procedure (.fex) are written in the WebFOCUS source code. These options are not affected by the selected Field List options.

Option

Description

Qualified field name

Writes the source code using qualified field names, for example:

BY ‘GGSALES.SALES01.CATEGORY’

Unqualified field name

Writes the source code using unqualified field names, for example:

BY CATEGORY

Alias field name

Writes the source code using alias field names, as defined in the ALIAS field of the Master File. The ALIAS field assigns an alternative name for a column.

The following example shows source code where the Category field name is assigned E02 in the ALIAS field of the ggsales.mas Master File.

BY E02

Other Options

Option

Description

Default Report Format

Select the display format for your reports. You may choose:

  • Web (HTML)
  • HTML active report
  • active report for Flash
  • active report for PDF
  • Adobe Acrobat (PDF)
  • Excel 2007
  • Excel 2000
  • PowerPoint
  • FOCUS default (This option applies whichever of the previous formats was set as an environment parameter.)
  • User

Maximum number of records to retrieve/Maximum number of readings to make

Specifies a limit on the number of records to retrieve from the data source. Setting a retrieval limit creates selection criteria for both Retrieval Limit and Read Limit dialog boxes. Use this when you need only a few records to test the design of a new report, or you know how many records meet the test criteria and want to stop a search after those records are retrieved. This reduces total retrieval time.

Default Style Template

Specifies the default style template file. By default, this file is named default.stl and is located in your Developer Studio bin directory. The default.stl file specifies the name of the default style sheet used for each development area (localhost, Data Servers, Managed Reporting, and Repository). You can edit this file.

Note: Managed Reporting is only for releases prior to WebFOCUS 8. Repository is only for WebFOCUS 8 and higher.

Within default.stl, there are four entries:

LOCAL=endeflt
DATASERVER=endeflt
MRE=endeflt
WFC=endeflt

LOCAL represents the localhost development area. DATASERVER represents the Data Servers development area. MRE represents the Managed Reporting development area. WFC represents the Repository development area.

You can change endeflt to point to any Reporting Server style sheet. By default, endeflt is used in all areas.

Default Report Template

Specifies the default report settings when you open Report Painter.



x
Setting the Default Report Format

How to:

The Reporting tab of the Developer Studio Options dialog box allows you to set a report format that will be used as the default format by Report Painter.



x
Procedure: How to Set the Default Report Format

The following procedure describes how to set the default report format. For this task, you will select the User format.

  1. From Developer Studio, click Window from the menu bar.
  2. Select Options.
  3. Select the Reporting tab.
  4. From the Default Report Format drop-down list, select the required format, as shown in the following image.

    User

  5. Click OK.

    The User output is now the Default Report Option in the Developer Studio Report Painter. The User format allows the developer to select the actual output type at run time. For example, a developer could choose to view a report as Excel 2007, PDF, active report for Flash, and more.


WebFOCUS