-
Using the Chart/Rollup Tool With Active Technologies Reports for Adobe Flash Player. The
Chart/Rollup Tool enables you to organize and summarize selected
columns of data in order for you to obtain a desired report. The Chart/Rollup
Tool contains a list of columns available in an active report, and
Group By and Measure sort fields. You can click and drag the desired
columns into the sort fields. Once you define the report, you can
display the data as a chart or Rollup Table.
-
Creating a Bubble Chart. You
can create a bubble chart by including a pair of columns for each
series on the chart. The value of the first column in a pair of columns
determines the position of each bubble in the series. The value
of the second column in the pair of columns determines the size
of each bubble in the series.
-
Formatting Legend Options for an Active Technologies Report for Adobe Flash Player. When
displaying an active report for Adobe Flash Player as a chart in Report
Painter, you can modify the legend options by using the Format tab
of the Report Options dialog box. When the chart is run, you can
click a Legend icon to show or hide the chart legend.
-
Creating an Active Technologies Chart With WebFOCUS Syntax. You
can use standard WebFOCUS GRAPH FILE syntax to create an active
chart. The GRAPH FILE syntax supports the following types of active
charts: Bar, Pie, Line, and Scatter.
In the GRAPH FILE procedure,
you can apply one of three output formats to the chart. AHTML generates
an HTML version of the chart, FLEX generates an SWF file for the
chart that is Adobe Flash Player compatible, and APDF generates
an SWF file for the chart that is Adobe Flash Player compatible,
embedded in a PDF file.
-
Chart Type Syntax. Active
Technologies supports many types of active charts. Depending on
the type that you are creating, you can:
- Use REPORT-VIEW syntax
to specify that an active report be displayed as an active chart
in a TABLE FILE procedure. You can then use CHART-TYPE syntax to specify
one of the chart types supported by Active Technologies, including
bar, pie, line, and scatter. Additional chart types are available
when the output format is FLEX, including doughnut, area, bubble,
radar, funnel, and pyramid.
- Use LOOKGRAPH syntax
in a GRAPH FILE procedure to generate an available active chart
for the output format AHTML, FLEX, or APDF. If there is no corresponding
chart type available in Active Technologies, the default bar chart
will be rendered.
-
Using the Pivot Tool With Active Technologies Reports for Adobe Flash Player. The
Pivot Tool enables you to create a Pivot Table in which columns
and rows of data are organized and summarized in the way that you
define.
The Pivot Tool contains a list of columns available in
the active report, and Group By, Across, and Measure sort fields.
Click and drag the columns into the desired sort field.
-
Using the Global Filter Icon. When
you run an active dashboard, you can apply a global filter to all
the reports on the dashboard, using the Global Filter icon. The
Global Filter icon is located at the top of an active dashboard,
to the right of the drop-down lists from which you select field
values.
On the Add Condition button on the Global Filter dialog
box, only the fields that are common to the active reports on the
active dashboard are listed. This feature enables you to quickly
identify, select, and filter on a field that is used in all reports.
-
Controlling the Pagination Options. For
active reports, you can customize the pagination bar to display
the range of records that appear on the current page of the report,
instead of displaying the default filtered number of records and
total number of records.
-
Showing the Grid Tool Menu Option for an Active Technologies Report. When
you create an active report with the Report Painter, you can choose whether
or not to show the Grid Tool menu option when the active report
is run. The Grid Tool enables you to change the column order, sort
multiple columns in ascending or descending order, hide or show
columns, add a calculation to a column, and add subtotals to the
report.
-
Using Active Technologies Report for PDF as the Output Format in Report Painter. The
active report for PDF output format is available in Report Painter
and generates the syntax ON TABLE PCHOLD FORMAT APDF for the procedure. This
output format provides the ability to include interactive Adobe
Flash Player compatible reports, dashboards, and animations in PDF documents.