Format Tab

In this section:

You use the Format tab to change the output type of the report, control the navigational settings of a report, and access the special features of a report. Accordingly, this tab contains the Output Types, Navigation, and Features groups. The Format tab is located at the top of the App Studio interface and is available only when you are creating a report. The Format tab is shown in the following image.

Format tab


Top of page

x
Output Types Group

How to:

The Output Types group enables you to choose the type of report (for example, PDF, Excel, or active report) that you would like to produce. You can also set the output format and the destination of the report using the elements in this group. The Output types group is shown in the following image.

Output Types group

The report type options are:

HTML

Changes the report output type to HTML. This is the default value.

active report

Changes the report output type to HTML active report (AHTML).

active flex

Changes the report output type to active Flex, which creates an HTML report for Adobe Flash Player.

PDF

Changes the report output type to PDF.

active PDF

Changes the report output type to active PDF, which creates a PDF report for Adobe Flash Player.

Excel

Changes the report output type to Excel. You can select the following types of Excel Reports: Excel XLSX, Excel XLS, Excel XLSX Formula, Excel XLS Formula, or the Excel XLS PivotTable.

PowerPoint

Changes the report output type to PowerPoint. You can select PowerPoint PPTX or PowerPoint PPT.

Output Format

Changes the output format of a report. The options that are available to you change depending on which output format you select. Formats are grouped into the following categories: Styled report formats, Unstyled formats, and Database formats.

Output Format Options

Opens the Output Format Options dialog box where you can set a report title, turn on line suppression, turn on Cascading StyleSheets, and set how to expand report rows.

Destination

Opens the Output Destination dialog box, where you can set the destination of your output to either Web Browser, Temporary File, or Save File. If you select Temporary File or Save File, you can set the name and location of that file using the Name text box and directory selection icon. For more information, see How to Set the Output Destination.



x
Procedure: How to Set the Output Destination

  1. On the Format tab, in the Output Types group, click Destination (PCHOLD).

    The Output Destination dialog box displays.

  2. For Destination, select one of the following options:
    • Web Browser (default)
    • Temporary File
    • Save File

    Note: If you select Temporary File or Save File, the Name field is activated.

  3. Enter a file name and click the ellipsis button (...)

    The File name and location dialog box displays.

  4. Select where you want to save the file.

    Note: The file name that you specified on the Output Destination dialog box is carried over to the Filename field in the File name and Location dialog box.

  5. Click OK.
  6. Click OK on the Output Destination dialog box.

Top of page

x
Navigation Group

In this section:

How to:

The navigation group contains the functionality for setting navigational options for your report (for example, adding a Table of Contents or freezing an area of the report). You can also page the report on-demand and control OLAP options from the Navigation group. The Navigation group is shown in the following image.

Navigation group

The commands are:

Table of Contents

Displays every value of the highest-level sort field as a hyperlink, and then toggles between a display of the entire report and a designated section. It also applies a dynamic table of contents to the first By field in an HTML report. You can select Report, Heading, or None.

Note: You create a Table of Contents on a BY field.

For more information, see How to Add a TOC or Disable the TOC Feature.

Freeze

Freezes the scrolling area of a report so that Headings or Footings display with the full report in a narrow browser window. You can select Off, On, Top, Bottom, or Custom. For more information, see How to Freeze the Area You Are Scrolling for HTML Report Output.

On-Demand Paging

Displays one page of an HTML report, where the server sends the report to your browser one page at a time. You can use controls on your browser to display the next or previous page, all pages, or to navigate to a specific page. You can select On or Off (default).

Auto Drill & Analysis

Controls the appearance of OLAP options, the OLAP Selections pane, and automatic drilldowns. It also opens the Auto Drill & Analysis dialog box. You can select options related to OLAP, the OLAP Selections pane, and automatic drilldowns.

Note: You can use the Auto Drill & Analysis with HTML reports only.

For more information, see Auto Drill & Analysis.



x
Procedure: How to Add a TOC or Disable the TOC Feature
  1. Select a BY column in your report.
  2. On the Format tab, in the Navigation group, click Table of Contents.
  3. Choose one of the following options:
    • Report to embed the TOC in the executed report as an expandable tree control.
    • Heading to add the By columns as the last objects in the page heading. The TOC appears in a drop-down list in the heading when the report is executed.
    • None to turn the TOC feature off.

      Tip: Click the Properties tab in the Object Inspector to verify that the Table of Contents is turned on.

    or

    1. Right-click the first By column in the Report canvas window and click Table of Contents.
    2. Select either Report, Header, or None.


x
Procedure: How to Freeze the Area You Are Scrolling for HTML Report Output

You can freeze page headings/footings, report headings/footings, column titles, and totals for your report output. The freeze option is available from the Navigation group of the Format tab.

  1. On the Format tab, in the Navigation group, select Freeze from the Report menu.
  2. Select the freeze type from the drop-down list.

    The options are:

    • Off. This is the default.
    • On. Freezes the headings/footings, column titles, and totals.
    • Top. Freezes the headings and column titles.
    • Bottom. Freezes the totals and footings.
  3. Save and run your report.


x
Auto Drill & Analysis

This section describes the functionality for Auto Drill & Analysis.

Auto Drill and Analysis
OLAP Options
  • Disabled. OLAP options are disabled and not shown in the OLAP report. By default, the Enable OLAP option is set to Disabled.
  • Off. Turns off the OLAP Control Panel and the OLAP Selections pane, but allows OLAP functionality from the report itself. You can access options on right-click menus, drag columns within the report, and use up and down arrows to sort columns from high-to-low or vice versa.
  • On. Provides access to the OLAP Selections pane from a square button to the left of the column titles. You can open the Control Panel by clicking the OLAP button in the OLAP report.
  • Top Panel. Opens the OLAP Selections pane above the report. The Measures, Graph, and Dimension controls, 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.
  • Bottom Panel. Opens the OLAP Selections pane below the report. The Measures, Graph, and Dimension controls, 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.
  • Hidden Panel. 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.
Auto Drill Options

Automatic Drill Down controls access to automatic drill downs in a report:

  • None. Disables automatic drill downs. By default, the Automatic Drill Down option is to None.
  • Dimensions. Enables automatic drill downs on dimensions in a report.
  • Dimensions and Measures. Enables automatic drill downs on dimensions and measures in a report.

Top of page

x
Features Group

In this section:

Options in the Features group enable to you control the appearance of pop-up descriptions, whether a report is an Accordion Report, whether to repeat a sorted value, whether to use special active report options, and if accessibility options are on. The Features group is shown in the following image.

Features group

The commands are:

Popup Description

Enables the display of pop-up field descriptions for columns in your report. You can select On or Off. The default is <not set>. For more information, see Displaying Pop-up Field Descriptions for Column Titles.

Accordion Report

Changes a report to an Accordion Report. You can select On or Off. Accordion reports provide a way to control the amount of sorted data that appears on an HTML report page. You can produce reports with expandable views of data for each vertical sort field. When an Accordion Report first appears, only data values of the first (highest-level) vertical sort field are shown. All other data is hidden. You can manually expand your view to expose data values of lower-level sort fields. For more information, see Controlling the Display of Sorted Data With Accordion Reports.

Repeat Sort Value

Displays all repeated sort values instead of blanks in the output after the first instance of a new sort value, which is the default behavior. You can select On or Off. The default is <not set>.

Lines per Page

Determines how many lines are displayed on each report page. Options are 10, 20, 30, 40, 50, and Show All. The default is 20.

Accessibility

Offers options that help users with disabilities to interact with the report.

Mailing Labels

Opens the Mailing Labels Options dialog box, which allows you customize the layout, dimensions, spacing, and print order of your mailing label. This option is only available for PDF and PostScript reports.

For more information, see Mailing Labels Options Dialog Box.



x
Displaying Pop-up Field Descriptions for Column Titles

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.

Note: Pop-up Field Descriptions are available for HTML Web Document (HTML), HTML Table (HTMTABLE), Default, and User styled report formats.

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.

The following procedure provides information on displaying pop-up descriptions in an HTML report.



x
Procedure: How to Display Pop-up Field Descriptions in an HTML Report
  1. Open a report in App Studio.
  2. On the Format tab, in the Features group, click Popup Desc.

    The selection menu displays.

  3. Select one of the following options:
    • On. Turns Pop-up Field Descriptions on.
    • Off. Turns Pop-up Field Descriptions off.
    • <not set>. Indicates that a value has not been set for Pop-up Field Descriptions. This is the default value.


x
Controlling the Display of Sorted Data With Accordion Reports

Accordion Reports provide a way to control the amount of sorted data that appears on an HTML report page. You can produce reports with expandable views of data for each vertical sort field. When an Accordion Report first appears, only data values of the first (highest-level) vertical sort field are shown. All other data is hidden. You can manually expand your view to expose data values of lower-level sort fields.

When you create an Accordion Report, a plus sign (+) appears to the left of each data value in the column under the highest-level sort heading. For data associated with lower-level sort fields, a plus sign (+) is placed to the left of each data value, but the data does not appear unless manually expanded. Data values of the lowest-level sort field are not expandable.

To expand your view of data for any expandable sort field, click a plus sign (+) and all data associated with the next lower-level sort field appears. When you expand a data value under the next to lowest sort heading, all of the remaining associated data values in the report appear.

Note: Two vertical (BY) sort fields are required. If your report does not contain two vertical sort fields, then the Accordion Reports option is ignored and a standard HTML report is created.

The use of horizontal (ACROSS) sort fields is supported with Accordion Reports. The horizontal sort headings that appear above vertical sort headings in a standard HTML report are not displayed in an Accordion Report until at least one sorted data value has been manually expanded in each expandable sort column.

PDF and Excel formats are not supported with Accordion Reports.



x
Reference: Requirements for Accordion Reports

The following requirements must be taken into consideration when creating Accordion Reports:

  • Adding a drill-down link to an Accordion Report requires that the TARGET parameter must be set to a value that specifies a new HTML frame.
  • Once an Accordion Report is created and delivered to the user, there are no subsequent calls to the WebFOCUS Reporting Server required when the user is interacting with the report. However, the collapsible folder controls on the sort fields require JavaScript and images that reside on the WebFOCUS Client. The user must be connected to the WebFOCUS Web tier components in order to use this feature. For online connected users of WebFOCUS, no change is required to the report.


x
Procedure: How to Create an Accordion Report
  1. Create a report in Report canvas using the GGSALES Master File.
  2. In the Report canvas main window, add the following fields:

    UNITS, ST, DOLLARS, CITY, REGION, CATEGORY

  3. Highlight the UNITS and DOLLARS fields and Sum these fields.
  4. Highlight the ST, CITY, and CATEGORY fields and make them By fields.
  5. On the Format tab, in the Features group, select Accordion Report.

    Note: Accordion Reports are available for HTML Web Document (HTML), HTML Table (HTMTABLE), Default, and User styled report formats.

  6. Select one of the following options:
    • On to turn on Accordion reports.
    • Off to turn off the feature and display the Accordion report.
    • <not set> to indicate no choice.

    Note: The default value is <not set>.



x
Mailing Labels Options Dialog Box

You can use the Mailing Labels Options dialog box to customize the settings for your mailing label. You can customize the layout, dimensions, spacing, and print order of your label.

Label Type
  • None. Removes all label settings in the Cascading Style Sheet.
  • Custom label. Enables you to specify custom label settings.
  • All other preset label types automatically load the appropriate settings into the Cascading Style Sheet.
Label layout

Sets the number of rows and columns for the labels.

Label dimensions

Determines the height and width of each label.

Label spacing

Determines the amount of horizontal and vertical spacing between each label (in the current units of measure).

Print order

Determines whether the data output flows down a column or across a row.

  • Down. Labels are printed top-to-bottom and moves left-to-right until each column is filled.
  • Across. Labels are printed left-to-right and then moves down until all rows are complete.

WebFOCUS