WebFOCUS Online Help > InfoAssist > Customizing and Styling Report Queries > Creating Customized Report Outputs
How to: |
In addition to HTML, Active Report, Active Flex, PDF, Active PDF, Excel, and PowerPoint output formats, you can create the following custom report output formats.
Selecting Pivot generates output with pivot table features. The following image is an example of a pivot table in Excel.
Note: The context menu automatically goes away after you click on one of the menu options, click the arrow again, or click anywhere else on the screen. This means only one selection or action can be performed in the context menu at a time.
Selecting OLAP panel not accessible means that only the sorting options will display in the column titles and the OCP (OLAP Control Panel) cannot be accessed from the title options.
Selecting OLAP panel accessible (the default) allows access to the OLAP panel using the OLAP button in the output of the report. Note: Using this option versus the hidden option allows the user to better distinguish the difference between the first and second options. The hidden option is available by accessing the Navigation dialog.
Selecting Dimension filtering enabled means that dimension filters are displayed at the top of the report. Customizing the filter placement must be done in the Navigation dialog (accessed by clicking More options…).
Selecting Dimensions grouped in tabs means that the dimension filters are grouped into tabs based on hierarchy/within statements in the metadata.
If you select More options, the OLAP Options dialog box opens, as shown in the following image.
The OLAP Options dialog box allows the following additional configuration/customization options for OLAP output.
Selecting an option from the OLAP group, such as OLAP panel is accessible, generates output that invokes OLAP processing. The following image is an example of an OLAP report. The OLAP button below the report launches the OLAP Control Panel when clicked.
A table of contents icon is displayed in the top left corner of the report output, as shown in the following image.
Drag the Table of Contents pop-up menu in any direction to view the report output, which is displayed behind the menu by default. Select a sort field to view values for that field. In the following example, clicking Espresso displays the corresponding report output.
You can also select options to view the entire report or remove the table of contents.
Selecting Freeze generates output with column titles that freeze (remain in view) when you scroll through pages of the report output.
Selecting Pages On Demand displays one page of output at a time. This option provides a menu bar at the bottom of the report output, as shown in the following image, where you can choose to view additional pages of output.
Selecting Accordion creates expandable views of data for each vertical sort field. This option displays data values only for the first vertical sort field when you first view the output. You can manually expand your view to expose the data values of lower-level sort fields, as shown in the following image.
When the Stacked Measures option is enabled, all measures on the report are stacked.
The following image shows the InfoAssist interface in Interactive Design view before the Stacked Measures button is clicked.
The following image shows the InfoAssist interface in Interactive Design view after the Stacked Measures button is clicked.
WebFOCUS |