Graphs are used to graphically represent data in SYSPRO.
Data can be displayed in various ways. A pie chart displays information in segments while a line chart displays data on an X and Y-axis. You can choose from a variety of chart types to display your data.
Legends identify the parts of a graph, while tooltips show more detail about the graph.
You can find graphs in a number of SYSPRO programs including Query programs and the Requirements Planning module, and you can add your own graphs using VBScripting,
| Field | Description | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Options |
|
||||||||||||||||||||||
| Show Chart in Image Viewer | Display the chart in your default image viewer. | ||||||||||||||||||||||
| Style | Change the color style of the graph. | ||||||||||||||||||||||
| Appearance | Choose a different background appearance for the chart. |
| Field | Description |
|---|---|
| Area chart |
An Area chart is similar to a Line chart, with the addition of the area between the line and the X axis being highlighted with a color. |
| Bar chart |
A Bar chart is a series of horizontal or vertical rectangular bars that are proportional in length to the value. One of the axes shows the categories to be compared and the other represents the discrete values. Bar charts make it easy to compare the values, although it is difficult to see the actual values without using the mouse pointer to display the tooltip. |
| Bubble chart | A Bubble chart is similar to a bar chart except that instead of showing the value as a bar, a circle is displayed. All the circles are the same size, and it is the center point of the circle that represents the value. |
| Funnel chart |
A Funnel chart is a chart in the shape of a funnel. It is typically used to represent values that will decrease, or start at 100% and end with a lower percentage. An example is the number of prospective customers in the sales cycle. It is the depth of each segment (not the width) that represents the value for each level. |
| Gantt chart |
A Gantt chart is typically used to show elements of a project or a job, and can also be used to show the dependencies between these. The names of the elements of the project or job run from top to bottom on the left of the chart. The number of days (or dates) appear across the top. Terminal elements appear as bars alongside the elements, and these consist of the planned values, and where appropriate, the actual values. A vertical progress line shows the current status of the project, or if dates are used the line represents today. |
| Line chart |
A Line chart consists of a series of points that are typically plotted on the X axis. Each point is joined to the next with a straight line. A line chart is typically used to show a trend in the data over a specific interval of time. |
| Pie chart |
A Pie chart is a circle divided up in a similar way to cutting a pie. Each pie 'slice' or segment is given a different color to differentiate them. The sum of all the values is divided by 360 to find the value of each degree, and the sizes are allocated accordingly. |
| Pyramid chart | A Pyramid chart consists of one of more segments making up a triangle. It is similar to a Funnel chart in that it is the height of each segment that is important, not the width or the area. |
| Scatter chart |
The Scatter chart in SYSPRO is a scatter line chart. A scatter chart is similar to a line chart, except the scatter chart will plot the data values in the exact order that they appear in the XML, and connect the points with a line. A line chart will always connect the points from left to right along the X axis. |
| Spline chart | A Spline chart is similar to a line chart, except that the lines between the points are curved instead of straight. |
| Step chart |
A Step chart is similar to a line chart except that the line between the values is always horizontal. When a value changes a step appears between the two levels. This is useful when showing quantities that change intermittently, but remain constant between these changes. It highlights the changes, whereas on a line chart this might not be noticeable for small changes. |
| Torus | A Torus chart is similar to a Pie chart except that it has a hole in the middle. This is usually a 3D object. |
| Series 2 | A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. |
| Series 3 | A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. |
| Stacked bar | A Stacked bar chart is similar to a Bar chart, except
that the series of horizontal or vertical rectangular bars are
segmented. Each bar in the chart represents a whole value, and
the segments in the bar proportionally represent the different
values which make up that whole value. It is used to compare parts of a whole dataset. |
You can use VBScript to control the creation of graphs. You define the structure and then populate it using XML. The definition would typically be against the OnLoad function, and the population against the OnRefresh function.
Sample XML is provided by the GraphData variable, but for a graph to be useful you need to populate the graph using real values (which is usually supplied by an e.net Solutions business object).
The following table describes the graph elements to use when adding your VBScript:
| Element | Description |
|---|---|
| Title |
This element resides within the Titles node and provides a title for the whole chart (i.e. the one at the top of the customized pane). It is used to specify whether the title should be displayed or not using the Visible attribute (where 0 is not to display, and 1 is to display). It also contains the title to be displayed against the Text attribute. |
| Labels |
This element is used to define whether the labels that appear alongside the axis containing the static information should be straight or angled. If this element is not present the labels will appear straight by default. |
| Legend |
This element is used to specify whether the box containing the legend should be displayed, and how many columns it should consume. The Legend is displayed if the Visible attribute is set to 1, and the number of columns to be displayed is defined using the ColumnCount attribute. |
| PanelDirection |
This element is used to specify whether the graph should appear in its standard orientation, or if it should be rotated through 90 degrees using the Rotated attribute. |
| Panel |
This element is used to supply information regarding the X and Y-Axis of the graph. These are defined within the AxisX and AxisY elements respectively. The X-Axis is the one that runs from left to right, and the Y-Axis is the one that runs from bottom to top. |
| Series |
This element is used to define the type of graph (using the Style attribute), what will appear within the Legend box (using the LegendText attribute), and to which Panel this Series entry relates (using the Panel attribute). There should be one Series element for each Panel when there are multiple graphs in one customized pane. |
| Tooltips | This displays a combination of the text supplied against the LegendText attribute of the Series element, the text supplied against the Label attribute of the Point element, and the value. This is displayed when you move your mouse pointer over the graph. |
-
Operator access to the following activities within this program can be restricted. You configure this using the Operators program.
Activity Description VBScript editing Controls whether an operator can edit VBScripts or change customized panes. It also controls whether an operator can access the Visual Designer program (displayed from the submenu of the 
icon). This does not apply to importing customized
panes, which is controlled by the Allow to import customized
panes activity.Listview/Forms - Export or print data Controls whether an operator can print the contents of a listview and/or output the contents of a listview to an HTML page, XML document or Excel spreadsheet.