You can use standard WebFOCUS GRAPH FILE syntax to create an active chart. The GRAPH FILE syntax supports the following types of active charts:
In the GRAPH FILE procedure, you can apply one of three output formats to the chart:
The following guidelines apply.
COMPOUND LAYOUT {PCHOLD|HOLD} FORMAT {AHTML|FLEX|APDF}
To create an active chart, use
ON GRAPH {PCHOLD|HOLD|SAVE} FORMAT {AHTML|FLEX|APDF}
where:
Displays the chart output in a Web browser in the format specified. PCHOLD is the default value.
Saves the chart output to a temporary file for later use. The output is saved with an associated Master File.
Saves the chart output to a file for later use, but the output is not saved with a Master File.
Creates an HTML version of the chart.
Creates an Adobe Flash Player version of the chart (Adobe Flash file).
Creates an Adobe Flash Player version of the chart (Adobe Flash file), embedded in a PDF file.
The following WebFOCUS code creates an Adobe Flash Player version of an active chart.
The code that controls the chart type (PIE) and the code that controls the output format (FLEX) is shown in bold.
The WebFOCUS StyleSheet code, which follows the code shown in bold, controls the way that the legend is displayed in the output. In this example, the legend is fixed. It appears underneath the chart. For more information on controlling the legend, see Controlling the Legend of an Active Technologies Chart in FLEX or APDF Format.
GRAPH FILE GGSALES SUM DOLLARS BY CATEGORY BY PRODUCT ON GRAPH SET LOOKGRAPH PIE ON GRAPH PCHOLD FORMAT FLEX ON GRAPH SET STYLE * TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=FLAT,$ ENDSTYLE END
The output is shown in the following image.
You can use the icons at the top of the chart as you do for charts that are generated by a graphical tool. For example, you can change the chart type from pie to bar.
The Chart Tool is accessible from the left-most icon at the top of the chart. The Chart Tool allows you to change the columns and switch the chart type.
How to: |
You can control the chart type using the WebFOCUS code ON GRAPH SET LOOKGRAPH.
To create a vertical bar chart, use
ON GRAPH SET LOOKGRAPH BAR
where:
Is the default value.
To create a vertical line chart, use:
ON GRAPH SET LOOKGRAPH LINE
To create a pie chart, use:
ON GRAPH SET LOOKGRAPH PIE
To create a scatter chart, use:
ON GRAPH SET LOOKGRAPH SCATTER
In this section: How to: |
You can control how to display the legend for an active chart in FLEX or APDF format, using WebFOCUS StyleSheet code. The legend can be fixed or collapsible.
A legend always appears on a pie chart. A legend appears on a bar, line, or scatter chart if the chart has more than one Y-axis field.
To display a fixed legend underneath the chart, use:
TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=FLAT,$
To display a collapsible legend at the position specified, use
TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=DOCKING,
POSITION-POINT={BOTTOM-LEFT|BOTTOM-CENTER|BOTTOM-RIGHT},$
where:
Is the default value.
The following WebFOCUS StyleSheet code generates a collapsible legend at the bottom right of an active pie chart in FLEX format.
TYPE=REPORT, OBJECT=LEGEND, LEGEND-VIEW=DOCKING, POSITION-POINT=BOTTOM-RIGHT,$
The output is shown in the following image. In the image, the cursor is pointing to the Legend icon at the bottom right of the chart.
You can:
The examples in this topic describe the supported chart legend syntax and the output that it generates.
GRAPH FILE vs. TABLE FILE
When you run a GRAPH FILE procedure to generate a chart, the output displays the chart toolbar above the chart. The result is the same when you run a TABLE FILE procedure with the initial report view set to a chart, using the following StyleSheet code:
TYPE=REPORT, REPORT-VIEW=CHART, CHART-TYPE=PIE,$
The chart that is generated runs inside a canvas frame, not inside a window or panel type of frame.
When you run a TABLE FILE procedure and you do not set the initial report view to a chart, WebFOCUS generates an active report that is in grid view. You can create a chart from a drop-down menu on the active report, using the Chart menu option. When you do that, the chart opens up inside a new window or panel type of frame. You can minimize, maximize, or close the window.
Examples
The WebFOCUS syntax generates the chart legend, as shown in the following image.
TYPE=REPORT,OBJECT=LEGEND,LEGEND-VIEW=FLAT,$
The WebFOCUS syntax generates the chart legend, as shown in the following image.
TYPE=REPORT,OBJECT=LEGEND,LEGEND-VIEW=DOCKING,POSITION-POINT=BOTTOM-CENTER,$
The WebFOCUS syntax generates the chart legend, as shown in the following image.
TYPE=REPORT,OBJECT=LEGEND,LEGEND-VIEW=DOCKING,POSITION-POINT= BOTTOM-RIGHT,$
The WebFOCUS syntax generates the chart legend, as shown in the following image.
How to: |
You may customize chart colors and styles for active reports and active dashboards by creating a JavaScript file to overwrite the default colors and styles used for charts. The customization steps vary, depending on the output format.
By default, the chart colors are stored in the irpfnc.js file, located in the Reporting Server \home\etc directory. Optionally, you may create a custom JavaScript file (using the file name irpcusf.js) in your application folder and add a line of JavaScript code to overwrite the default color settings. Customizing the colorTable RGB color codes in this JavaScript file enables you to edit the series colors of active charts. The irpcusf.js file overwrites the default colors used for charts and applies changes to all chart types in active reports and active dashboards using the HTML output format.
By default, the chart styles are stored in the irpfsty.js file, located in the Reporting Server \home\etc directory. Optionally, you may copy this file to your application folder and edit the chart series StyleSheet section. This enables you to customize the look and feel of charts and gives you full control over styling individual chart types using Cascading Style Sheet syntax. You can apply different sets of colors to Pie, Bar, Line, and Scatter chart as needed. In addition to changing chart series colors, you can customize the labels to display inside or outside the Pie chart, change the legend font colors, and add background colors to Bar, Line, and Scatter charts.
For all output formats, if these customized JavaScript files exist in your application folder, the default styles are overwritten by the colors and styles specified. You can have different customized JavaScript files in your application folder, enabling you to update the active reports and active dashboards in your existing applications with different styles and color themes to meet your needs.
By creating the irpcusf.js JavaScript file, you may add JavaScript code to customize the colorTable RGB color codes for charts in active reports and active dashboards in HTML.
This should be the same directory as the location of the active report or active dashboard. For example, from the Projects area of Developer Studio, create a new JScript Script File in the Other subfolder of the project folder.
colorTable["ibi"]=[[0,121,193],[127,173,220],[84,12,182], [161,161,217],[46,46,171],[105,3,164],[9,184,206]];
The numbers represent the array of colors for active chart series using colorTable RGB color codes. Enter the series color of your choice separated by commas, no spaces, and brackets.
The next time you run an active report or active dashboard, the charts appear with the series colors you selected in the customized JavaScript file.
The following image shows an active dashboard, using the HTML output format, with customized chart colors.
By copying and pasting the irpfsty.js JavaScript file, you may edit JavaScript code to customize the Cascading Style Sheet syntax for charts in active reports and active dashboards for Adobe Flash Player and for PDF.
This should be the same directory as the location of the active report or active dashboard. For example, from the Projects on localhost area in Developer Studio, paste irpfsty.js in the Other subfolder of the project folder.
Tip: Cascading Style Sheet syntax uses HTML color code or hex values for the colors. For details on each available property, see the Adobe documentation.
Currently, you may only modify the first series in a pie chart of the active report for Adobe Flash Player.
.arPieChartStyle { chartSeriesStyles: arPieSeries1, arPieSeries2, arPieSeries3; } .arPieSeries1 { fills: #35675B, #A4C366, #FFAC1B, #618466, #E4CDAD, #3f9f3f, #aca52d, #09cf6b, #d4dc7f, #B50CB1; color: #408a1c; fontWeight: bold; labelPosition: outside; }
where:
A single array of colors to specify the individual color for each pie chart wedge.
The color of the text used in the chart, including the label.
Sets the text to be in boldface.
Specifies how to display data labels for the pie chart wedges. The default is none. The possible values are:
You can add as many series as needed. The number of series specified in the array for arBarChartStyle has to correspond with the number of bar series defined.
.arBarChartStyle{ chartSeriesStyles: arBarSeries1, arBarSeries2, arBarSeries3, arBarSeries4, arBarSeries5, arBarSeries6, arBarSeries7, arBarSeries8, arBarSeries9, arBarSeries10; } .arBarSeries1 { fill: #35675B; } .arBarSeries2 { fill: #A4C366; } .arBarSeries3 { fill: #FFAC1B; } … }
where:
Sets the color for each series in a chart.
You can add as many series as needed. The number of series specified in the array for arLineChartStyle has to correspond with the number of line series defined.
.arLineChartStyle{ chartSeriesStyles: arLineSeries1, arLineSeries2, arLineSeries3, arLineSeries4, arLineSeries5, arLineSeries6, arLineSeries7, arLineSeries8, arLineSeries9, arLineSeries10; } .arLineSeries1 { form: curve; color: #35675B; weight: 2; } .arLineSeries2{ color: #A4C366; weight: 2; } .arLineSeries3 { color: #FFAC1B; weight: 2; } … }
where:
Sets the line type for the chart. The default is segment. Possible values are:
Sets the color of the line.
Sets the width of the line in pixels. The default value is 0.
You can add as many series as needed. The number of series specified in the array for arScatterChartStyle has to correspond with the number of scatter chart series defined.
.arScatterChartStyle{ chartSeriesStyles: arScatterSeries1, arScatterSeries2, arScatterSeries3, arScatterSeries4, arScatterSeries5, arScatterSeries6, arScatterSeries7, arScatterSeries8, arScatterSeries9, arScatterSeries10; } .arScatterSeries1 { fill: #35675B; radius: 8; } .arScatterSeries2 { fill: #A4C366; } .arScatterSeries3 { fill: #FFAC1B; } … }
where:
Sets the radius of the plot point in pixels. The default value is 5 pixels.
For example, the following syntax applies the alternate background color and changes the font color of the legend:
Legend { color: #306814; } GridLines { horizontalAlternateFill: #e8f7e6; horizontalFill: #f5fbf1; }
For example, the following code applies the different colors and font styles to the tabs, pull down menu, and text in the dashboard:
TabNavigator { backgroundColor: #d8fcb1; borderColor: #118822; color: #35675b; tabStyleName: "myTabs"; firstTabStyleName: "myTabs"; lastTabStyleName: "myTabs"; } .myTabs { fillColors: #ffffff, #a6cdb1; borderColor: #118822; color: #35675b; textRollOverColor: #118822; themeColor: #35675b; } ComboBox { color: #35675b; borderColor: #118822; iconColor: #35675b; selectionColor: #2cd61c; textSelectedColor: #254941; rollOverColor: #9eefaa; textRollOverColor: #075812; themeColor: #35675b; dropdownStyleName: "myComboBoxDropDowns"; } .myComboBoxDropDowns { borderColor: #118822; color: #35675b; } Text { color: #35675b; fontWeight: bold; }
The next time you run an active report or active dashboard, the charts appear with the colors and styles you selected in the customized JavaScript file.
The following image shows an active dashboard for PDF with fully customized style.
In this section: How to: |
Active Technologies for Adobe Flash Player allow you to customize how a chart is displayed on an active report or active dashboard. There are three separate animation effects that you can use: SeriesInterpolate, SeriesSlide, and SeriesZoom. You can control the properties of each effect to achieve a distinct impact.
All the styling options for the charts in Active Technologies for Adobe Flash Player are stored in the irpfsty.js file, found in the \home\etc directory of the WebFOCUS Reporting Server. You can copy this file to your application folder and edit the contents to customize the charts for your application.
The animation effects used in the charts are listed at the top of the irpfsty.js file, as shown here.
<mx:SeriesSlide id="lineShowEffect" duration="2000"/> <mx:SeriesSlide id="lineHideEffect" duration="2000"/> <mx:SeriesSlide id="scatterShowEffect" duration="2000"/> <mx:SeriesSlide id="scatterHideEffect" duration="2000"/> <mx:SeriesInterpolate id="barShowEffect" duration="2000" elementOffset="10" /> <mx:SeriesSlide id="XbarShowEffect" direction="up" duration="2000"/> <mx:SeriesSlide id="XbarHideEffect" direction="down" duration="2000"/> <mx:SeriesInterpolate id="pieShowEffect" duration="2000" elementOffset="10" />
Active Technologies determine which effect to use by the id specified in this section.
For example, you can edit this section to change the bar chart effect to slide instead of interpolate by commenting out the existing barShowEffect element. You would set the id for SeriesSlide to “barShowEffect" and set the direction of the slide to "right," as shown in the following procedure.
This should be the same directory as the location of the active report or active dashboard. For example, from the Projects on localhost area in Developer Studio, paste irpfsty.js in the Other subfolder of the project folder.
<!-- <mx:SeriesInterpolate id="barShowEffect" duration="2000" elementOffset="10" /> -->
<mx:SeriesSlide id="barShowEffect" direction="right" duration="2000"/>
The code will look like the following:
<!-- <mx:SeriesInterpolate id="barShowEffect" duration="2000" elementOffset="10" /> --> <mx:SeriesSlide id="barShowEffect" direction="right" duration="2000"/>
Tip: Adding <!-- at the beginning of the first XML tag and --> at the end of the closing XML tag comments out the entire section.
One of the effects that is not included in the irpfsty.js file is SeriesZoom.
In order to use this effect, you need to add it to the irpfsty.js file. You also need to include the datavisualization.swc file in your WebFOCUS Reporting Server \home\etc\flex\frameworks\libs folder. The datavisualization.swc file is found in your Adobe Flex Builder SDK directory, typically in \Program Files\Adobe\Adobe Flex Builder 3\sdks\3.5.0 (or 3.4.0)\frameworks\libs.
Then you can comment out the existing pieShowEffect element, and add the SeriesZoom effect as pieShowEffect, as shown in the following example.
<!-- <mxSeriesInterpolate id="pieShowEffect" duration="2000" elementOffset="10" /> -->
<mx:SeriesZoom id="pieShowEffect" duration="2000" elementOffset="-50"
minimumElementDuration="50" verticalFocus="top" horizontalFocus="right"
relativeTo="chart" />
You can find more information on each effect and its properties in the Adobe documentation.
Active Technologies support many types of active charts. Depending on the type that you are creating, you can:
This topic describes the CHART-TYPE syntax and the LOOKGRAPH syntax that you can use to create the available types of active charts.
Bar Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
BAR |
ON GRAPH SET LOOKGRAPH BAR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
HBAR |
ON GRAPH SET LOOKGRAPH HBAR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
3DBAR |
ON GRAPH SET LOOKGRAPH 3DBAR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
NONE |
ON GRAPH SET LOOKGRAPH NONE |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
CUSTOM |
ON GRAPH SET LOOKGRAPH CUSTOM |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
HBAR2AX |
ON GRAPH SET LOOKGRAPH HBAR2AX |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSBar2D,$ | |
HBAR2AXS |
ON GRAPH SET LOOKGRAPH HBAR2AXS |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
STACK |
ON GRAPH SET LOOKGRAPH STACK |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
HBRSTK1 |
ON GRAPH SET LOOKGRAPH HBRSTK1 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
3DSTACK |
ON GRAPH SET LOOKGRAPH 3DSTACK |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
HBRSTKPC |
ON GRAPH SET LOOKGRAPH HBRSTKPC |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
HBRSTK2 |
ON GRAPH SET LOOKGRAPH HBRSTK2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ | |
HBRSTK2S |
ON GRAPH SET LOOKGRAPH HBRSTK2S |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedBar2D,$ |
Column Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
VBAR |
ON GRAPH SET LOOKGRAPH VBAR |
TYPE=REPORT,REPORT- VIEW=CHART,CHART-TYPE=BAR,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSColumn2D,$ | |
3D_BAR |
ON GRAPH SET LOOKGRAPH 3D_BAR |
TYPE=REPORT,REPORT- VIEW=FUSIONCHART,CHART-TYPE=MSColumn3D,$ |
3DGROUP |
ON GRAPH SET LOOKGRAPH 3DGROUP |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=MSColumn3D,$ |
VBAR2AX |
ON GRAPH SET LOOKGRAPH VBAR2AX |
TYPE=REPORT,REPORT- VIEW=CHART,CHART-TYPE=BAR,$ |
VBAR2AXS |
ON GRAPH SET LOOKGRAPH VBAR2AXS |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=BAR,$ |
MULTI3Y |
ON GRAPH SET LOOKGRAPH MULTI3Y |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=BAR,$ |
MULTI4Y |
ON GRAPH SET LOOKGRAPH MULTI4Y |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=BAR,$ |
MULTI5Y |
ON GRAPH SET LOOKGRAPH MULTI5Y |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=BAR,$ |
VBRSTK1 |
ON GRAPH SET LOOKGRAPH VBRSTK1 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn2D,$ | |
VBRSTKPC |
ON GRAPH SET LOOKGRAPH VBRSTKPC |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn2D,$ | |
VBRSTK2 |
ON GRAPH SET LOOKGRAPH VBRSTK2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn2D,$ | |
VBRSTK2S |
ON GRAPH SET LOOKGRAPH VBRSTK2S |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=StackedColumn2D,$ |
Pie Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
PIE |
ON GRAPH SET LOOKGRAPH PIE |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=PIE,$ |
PIESINGL |
ON GRAPH SET LOOKGRAPH PIESINGL |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=PIE,$ |
PIEMULTI |
ON GRAPH SET LOOKGRAPH PIEMULTI |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Pie3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Pie2D,$ | |
PIEMULTP |
ON GRAPH SET LOOKGRAPH PIEMULTP |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Pie3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Pie2D,$ | |
PIEBAR |
ON GRAPH SET LOOKGRAPH PIEBAR |
TYPE=REPORT,REPORT-VIEW=CHART,CHART-TYPE=PIE,$ |
Doughnut Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
PIERING |
ON GRAPH SET LOOKGRAPH PIERING |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut2D,$ | |
PIEMULPR |
ON GRAPH SET LOOKGRAPH PIEMULPR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut2D,$ | |
PIEMULTR |
ON GRAPH SET LOOKGRAPH PIEMULTR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut2D,$ | |
PIERBAR |
ON GRAPH SET LOOKGRAPH PIERBAR |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut3D,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART,CHART-TYPE=Doughnut2D,$ |
Line Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
LINE |
ON GRAPH SET LOOKGRAPH LINE |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLINE |
ON GRAPH SET LOOKGRAPH HLINE |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLINE2 |
ON GRAPH SET LOOKGRAPH HLINE2 |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLINE2S |
ON GRAPH SET LOOKGRAPH HLINE2S |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLINSTK |
ON GRAPH SET LOOKGRAPH HLINSTK |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLINSTK2 |
ON GRAPH SET LOOKGRAPH HLINSTK2 |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLNSTK2S |
ON GRAPH SET LOOKGRAPH HLNSTK2S |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
HLNSTKPC |
ON GRAPH SET LOOKGRAPH HLNSTKPC |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
VLINE |
ON GRAPH SET LOOKGRAPH VLINE |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSLine,$ | |
VLINE2 |
ON GRAPH SET LOOKGRAPH VLINE2 |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
ON GRAPH SET 3D OFF |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSLine,$ | |
VLINE2S |
ON GRAPH SET LOOKGRAPH VLINE2S |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
VLINSTK |
ON GRAPH SET LOOKGRAPH VLINSTK |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
VLINSTK2 |
ON GRAPH SET LOOKGRAPH VLINSTK2 |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
VLNSTK2S |
ON GRAPH SET LOOKGRAPH VLNSTK2S |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
VLNSTKPC |
ON GRAPH SET LOOKGRAPH VLNSTKPC |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=LINE,$ |
Area Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
AREA |
ON GRAPH SET LOOKGRAPH AREA |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
HAREA |
ON GRAPH SET LOOKGRAPH HAREA |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
HAREAR2 |
ON GRAPH SET LOOKGRAPH HAREAR2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
HAREASTK |
ON GRAPH SET LOOKGRAPH HAREASTK |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
HARESTKP |
ON GRAPH SET LOOKGRAPH HARESTKP |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
HARESTK2 |
ON GRAPH SET LOOKGRAPH HARESTK2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
VAREA |
ON GRAPH SET LOOKGRAPH VAREA |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
3DAREAS |
ON GRAPH SET LOOKGRAPH 3DAREAS |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
3DAREAG |
ON GRAPH SET LOOKGRAPH 3DAREAG |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
VAREAR2 |
ON GRAPH SET LOOKGRAPH VAREAR2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSArea,$ |
VAREASTK |
ON GRAPH SET LOOKGRAPH VAREASTK |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
VARESTKP |
ON GRAPH SET LOOKGRAPH VARESTKP |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
VARESTK2 |
ON GRAPH SET LOOKGRAPH VARESTK2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=StackedArea2D,$ |
Scatter Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
SCATTER |
ON GRAPH SET LOOKGRAPH SCATTER |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=SCATTER,$ |
SCATTERS |
ON GRAPH SET LOOKGRAPH SCATTERS |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Scatter,$ |
SCATTRLS |
ON GRAPH SET LOOKGRAPH SCATTRLS |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=SCATTER,$ |
SCATTRLD |
ON GRAPH SET LOOKGRAPH SCATTRLD |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Scatter,$ |
SCATTERD |
ON GRAPH SET LOOKGRAPH SCATTERD |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Scatter,$ |
SCATTERN |
ON GRAPH SET LOOKGRAPH SCATTERN |
TYPE=REPORT,REPORT-VIEW=CHART, CHART-TYPE=SCATTER,$ |
Bubble Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
BUBBLE |
ON GRAPH SET LOOKGRAPH BUBBLE |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Bubble,$ |
BUBBLED |
ON GRAPH SET LOOKGRAPH BUBBLED |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Bubble,$ |
BUBBLEDL |
ON GRAPH SET LOOKGRAPH BUBBLEDL |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Bubble,$ |
BUBBLEL |
ON GRAPH SET LOOKGRAPH BUBBLEL |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Bubble,$ |
Radar Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
RADARA |
ON GRAPH SET LOOKGRAPH RADARA |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
RADARL |
ON GRAPH SET LOOKGRAPH RADARL |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
RADARL2 |
ON GRAPH SET LOOKGRAPH RADARL2 |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
RADARAG |
ON GRAPH SET LOOKGRAPH RADARAG |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
RADARL2G |
ON GRAPH SET LOOKGRAPH RADARL2G |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
RADARLG |
ON GRAPH SET LOOKGRAPH RADARLG |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Radar,$ |
Funnel Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
FUNNEL |
ON GRAPH SET LOOKGRAPH FUNNEL |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Funnel,$ |
Pyramid Chart Types
Type |
LOOKGRAPH Syntax |
CHART-TYPE Syntax |
---|---|---|
PYRAMID |
ON GRAPH SET LOOKGRAPH PYRAMID |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Pyramid,$ |
Additional Active Technologies Chart Types Available With CHART-TYPE Syntax
The following table lists additional active chart types that you can generate when running a TABLE FILE procedure, using CHART-TYPE syntax.
Chart Name |
CHART-TYPE Syntax |
---|---|
Column 3D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Column3D,$ |
Scroll Multi-Series Column 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=ScrollColumn2D,$ |
Scroll Stacked Column 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=ScrollStackedColumn2D,$ |
Logarithmic Multi-Series Column 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=LogMSColumn2D,$ |
Inverse Y-Axis Multi-Series Column 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=InverseMSColumn2D,$ |
Bar 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Bar2D,$ |
Line 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Line,$ |
Scroll Multi-Series Line 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=ScrollLine2D,$ |
Logarithmic Multi-Series Line |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=LogMSLine,$ |
Inverse Y-Axis Multi-Series Line 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=InverseMSLine,$ |
Spline |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Spline,$ |
Multi-Series Spline |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSSpline,$ |
Area 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=Area2D,$ |
Scroll Multi-Series Area 2D |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=ScrollArea2D,$ |
Inverse Y-Axis Multi-Series Area |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=InverseMSArea,$ |
Spline Area |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=SplineArea,$ |
Multi-Series Spline Area |
TYPE=REPORT,REPORT-VIEW=FUSIONCHART, CHART-TYPE=MSSplineArea,$ |
Chart Types Mapped to Default Chart Types
The following table lists the chart types that are mapped to the default bar type or to another type when there is no corresponding chart type available in Active Technologies. LOOKGRAPH syntax is used.
Type |
LOOKGRAPH Syntax |
Mapped To |
---|---|---|
3DCONE |
ON GRAPH SET LOOKGRAPH 3DCONE |
BAR |
3DCUBE |
ON GRAPH SET LOOKGRAPH 3DCUBE |
BAR |
3DCYLDER |
ON GRAPH SET LOOKGRAPH 3DCYLDER |
BAR |
3DGLOBE |
ON GRAPH SET LOOKGRAPH 3DGLOBE |
BAR |
3DOCTAGN |
ON GRAPH SET LOOKGRAPH 3DOCTAGN |
BAR |
3DPYRAMD |
ON GRAPH SET LOOKGRAPH 3DPYRAMD |
BAR |
3DRIBBNG |
ON GRAPH SET LOOKGRAPH 3DRIBBNG |
LINE |
3DRIBBNS |
ON GRAPH SET LOOKGRAPH 3DRIBBNS |
LINE |
3DSMOOTH |
ON GRAPH SET LOOKGRAPH 3DSMOOTH |
MSArea |
3DSPHERE |
ON GRAPH SET LOOKGRAPH 3DSPHERE |
BAR |
3DSURFCE |
ON GRAPH SET LOOKGRAPH 3DSURFCE |
LINE |
3DSURFHC |
ON GRAPH SET LOOKGRAPH 3DSURFHC |
MSArea |
3DSURFSD |
ON GRAPH SET LOOKGRAPH 3DSURFSD |
MSArea |
BOXPLOT |
ON GRAPH SET LOOKGRAPH BOXPLOT |
BAR |
ERRORBAR |
ON GRAPH SET LOOKGRAPH ERRORBAR |
BAR |
HHISTOGR |
ON GRAPH SET LOOKGRAPH HHISTOGR |
BAR |
HWATERFL |
ON GRAPH SET LOOKGRAPH HWATERFL |
BAR |
PARETO |
ON GRAPH SET LOOKGRAPH PARETO |
BAR |
POLAR |
ON GRAPH SET LOOKGRAPH POLAR |
Radar |
POLAR2 |
ON GRAPH SET LOOKGRAPH POLAR2 |
Radar |
POSITION |
ON GRAPH SET LOOKGRAPH POSITION |
SCATTER |
RESOURCE |
ON GRAPH SET LOOKGRAPH RESOURCE |
BAR |
SPECTRAL |
ON GRAPH SET LOOKGRAPH SPECTRAL |
BAR |
STOCK |
ON GRAPH SET LOOKGRAPH STOCK |
BAR |
STOCKC |
ON GRAPH SET LOOKGRAPH STOCKC |
BAR |
STOCKCV |
ON GRAPH SET LOOKGRAPH STOCKCV |
BAR |
STOCKH |
ON GRAPH SET LOOKGRAPH STOCKH |
BAR |
STOCKHB |
ON GRAPH SET LOOKGRAPH STOCKHB |
BAR |
STOCKHC |
ON GRAPH SET LOOKGRAPH STOCKHC |
BAR |
STOCKHCB |
ON GRAPH SET LOOKGRAPH STOCKHCB |
BAR |
STOCKHCD |
ON GRAPH SET LOOKGRAPH STOCKHCD |
BAR |
STOCKHCL |
ON GRAPH SET LOOKGRAPH STOCKHCL |
BAR |
STOCKHCV |
ON GRAPH SET LOOKGRAPH STOCKHCV |
BAR |
STOCKHD |
ON GRAPH SET LOOKGRAPH STOCKHD |
BAR |
STOCKHOB |
ON GRAPH SET LOOKGRAPH STOCKHOB |
BAR |
STOCKHOC |
ON GRAPH SET LOOKGRAPH STOCKHOC |
BAR |
STOCKHOD |
ON GRAPH SET LOOKGRAPH STOCKHOD |
BAR |
STOCKHOV |
ON GRAPH SET LOOKGRAPH STOCKHOV |
BAR |
STOCKHV |
ON GRAPH SET LOOKGRAPH STOCKHV |
BAR |
STOCKLCV |
ON GRAPH SET LOOKGRAPH STOCKLCV |
BAR |
VHISTOGR |
ON GRAPH SET LOOKGRAPH VHISTOGR |
BAR |
VWATERFL |
ON GRAPH SET LOOKGRAPH VWATERFL |
BAR |
WebFOCUS |