In addition to HTML, active report, active Flash, PDF, active PDF, Excel, and PowerPoint output formats, you can create the following custom report output formats.
The WebFOCUS Viewer saves the bulk of your report to your web server and delivers one page of report output at a time, decreasing the amount of time that you wait for the report to process.
The bulk of your report remains on the web server until you request it or close the WebFOCUS Viewer.
The WebFOCUS Viewer menu bar, at the bottom of the Viewer, contains options for navigating through the pages. For more information on these options, see How to Create Pages On Demand Reports.
The Auto Drill & Analysis menu opens. It contains the following options:
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 box.
In addition to the options discussed previously, the Auto Drill & Analysis dialog box allows the following additional configuration and customization options for OLAP output:
Note: If the Dimension filtering enabled option is cleared at any time, the position option resets to Top.
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, when clicked, launches the OLAP ribbon.
Note: You cannot use the Table of Contents with the Accordion feature.
When you run the report, a table of contents button appears in the top-left corner of the report output, as shown in the following image.
Drag the Table of Contents menu in any direction to view the report output, which appears behind the menu by default.
Select a sort field to view values for that field. In the following example, clicking NorthEast displays the corresponding report output.
You can also select options to view the entire report or remove the table of contents.
On the Format tab, in the Navigation group, click Freeze.
Column titles freeze (remain in view) when you scroll through pages of the report output.
The following image shows the scroll bar that appears when you freeze column titles.
This procedure describes using the Pages on Demand feature to create an HTML report.
The default output is HTML.
The report opens in the WebFOCUS Viewer, as shown in the following image.
The options are:
Note: You cannot use the Table of Contents in conjunction with the Accordion feature.
The following image shows a report before the accordion option is applied.
Plus signs, shown in the following image, indicate that there are expandable views of data for each vertical sort field.
You can manually expand your view to expose the data, as shown in the following image.
On the Format tab, in the Features group, click Stack Measures.
All measure fields on the report are stacked.
The following image shows a report in Live Preview before the Stack Measures option is enabled.
The following image shows a report in Live Preview after the Stack Measures option is enabled.
For more information on Stacked Measures, see the Stacking Columns topic in the Creating Reports With WebFOCUS Language manual.