In this section: How to: |
WebFOCUS Report Assistant is an HTML-based graphical tool that enables you to select a data source, specify any sorting or grouping information, and display the report in your browser or another desktop application. For more information about the Report Assistant, see the Creating Reports With Report Assistant manual.
Open or create a report with Report Assistant.
Tip: Select FLEX - active report Flash to create an active report for Adobe Flash Player.
The active report styling dialog box opens.
Reference: |
You can apply the following custom formatting to an active report.
The following are active report styling options.
You can set the report view as a standard table (Tabular) or as an expandable report (Accordion). An expandable report is a collapsed report that can be fully expanded for sorting and other purposes.
If you are working with an Accordion active report, the Freeze columns option and Pagination options are not available.
Accordion Reports are not supported when creating HTML active reports using active cache and active reports for Adobe Flash Player.
Accordion Reports do not work when using By Hierarchy data.
You can set the justification for the information that appears in the record status and page navigation bar. You can also set the number of records that appear per page.
The following are the pagination options for active reports.
Justifies the text that appears in the record status and page navigation bar. Options are Left, Center, and Right. Left is the default.
Sets the number of records that appear per page. Options are Default, 10, 20, 30, 40, 50, Show All. The default is 57 lines per page.
Sets the color for the text in the record status and page navigation bar. The default is black.
Sets the background color for the record status and page navigation bar. The default color is silver.
Pagination options are not available for expandable report (Accordion) views.
An active report offers visual assistance for viewing data in the report. For example, when a user hovers over a row of data, the row is highlighted with a background color, and when they click a row of data, it is also highlighted with a background color. You can set the colors for these options, Hover and Selected. The default color for Hover is RGB(255 252 204), which is a pale yellow, and the default color for Selected is RGB(51 255 204), which is blue-green.
Users can apply data visualization to numeric fields in an active report. You can designate the colors of the bars. You can set different colors for positive and negative values. The default color for positive and negative values is black.
You can freeze the report at a particular point so that columns to the left of the freeze point remain in view while the user scrolls through the other report columns. Options include:
The Freeze columns option is not available for expandable report (Accordion) views.
Sets options for calculations.
Specifies the colors for the values in a calculation.
Sets the location of the calculations. Options are Top row or Bottom row. Top row is the default.
Set options for the menu.
Enables you to set the colors for the menu text.
Set the colors for the menu.
Select this option to enable active cache.
Because all post-retrieval processing is performed in the memory of the Web browser, an active report has a processing limit of approximately 5,000 records or 100 pages of output. The active cache option enables you to send only the first page of active report output to the browser and retrieve subsequent pages from a temporary cache on the WebFOCUS Reporting Server. The server also becomes the resource for performing all calculations, sorting, and filtering when active cache is enabled. Since active cache uses on-demand paging functionality, WebFOCUS Viewer is not supported.
In Report Assistant, the active cache option is not applicable to active reports for Adobe Flash Player.
WebFOCUS |