WebFOCUS Designer


Styling Column and Row Totals in a Report

As with the data values in a report, you can apply styling to the row and column totals and subtotals in a report to visually separate them from the rest of the values in your report and to draw attention to them. To add row and column totals to a report, on the Settings tab, in the Content Settings area, select Enable column totals and Enable row totals. To add subtotals, right-click a field in the Rows bucket of a report, point to Insert breaks, and select an option from the Subtotals section of the Insert breaks menu.

Formatting Cells in a Report

You can style the body of your report by specifying cell background colors, and setting cell margins. These options can help to make your report more legible by separating and spacing out the text, and by delineating different rows of data. On the Format tab, select General from the quick access menu to apply this formatting to the entire report. Select Columns and then make selections from the Select Elements and Column menus to apply cell formatting to the data values, column headers, or both areas of the selected column or columns.

Applying Themes to Reports

On the Format tab, in the General settings, in the General Options section, you can select a theme (.sty file, or StyleSheet), to apply to your report from the Theme menu. Themes style multiple components of a report, such as headers, column titles, and data text, all at once. Themes include associated cascading style sheet files along with a StyleSheet to help coordinate styling between an individual report and the entire visualization.

Setting General and Columnar Report Properties

When you select General from the quick access menu on the Format tab, you are presented with options to style and format the entire report. These options include the ability to set a theme, change the output format, change the font style and size, set cell margins, and configure how column widths are set. Font and cell styling options can be set for the entire report, or for specific columns within it.

Adding Filters to Pages Assembled From External Content

When you assemble a page from existing content, using the Assemble Visualizations option, the Filters tab on the sidebar allows you to display and chain filter controls. When you add an existing chart or report to a page, WebFOCUS Designer identifies any parameters present in the item. A badge appears on the Filters tab on the sidebar, indicating that you can add filters to the page, as shown in the following image.


Changing Metadata Classification Values When Uploading Data Files

When uploading a data file, you can view the recommended metadata classification values for each character-valued column. You can choose to keep the recommended values, or to change them.

Including classification values in your data improves the accuracy of mapping column tables correctly to each other. This is useful if you are integrating data from multiple sources, or if integrating data into a system with a predefined hierarchy. When creating unions from different data sources, the metadata classification algorithm will match columns with similar data.

Video: How to Use New or Existing Content in Pages

Using WebFOCUS Designer, you can create a single content item – either a chart or report – or you can create a page that contains multiple items. There are two different kinds of pages.  These pages are similar in appearance and general functionality, but provide a slightly different set of options, particularly when it comes to filtering behavior.    Show a finished page

Bookmarking Control Selections in a Page

Bookmarking allows users to save filter control selections and other run-time content customizations that they make in a page so that they can easily reapply them when they run the page again later. This is especially useful when there are many filter controls on a page that a user may want to apply each time they access it. Bookmarks are personal to each user and can easily be created and deleted as needed.