Collapse AllExpand All

3.15. Graph Editor

'Insert Graph' Icon

The Graph icon enables you to create new graph objects. Graph objects are used to insert graphs into a report definition using dynamic data stored in a database the report writer is connected to.

To create a new graph object, first select the Graph icon. Then click in the section of the report definition where you want the graph to be located. Doing so will create the graph object in that section.

Note

For more information on using graph objects in report definitions, see the Advanced Topics chapter.

Once the graph object has been created, you may then edit the graph object's properties. To edit a graph object's properties, double-click on the graph object. The following screen will appear:

Graph Editor

When editing the general properties of a graph object, you are presented with the following options:

Query Source

Select a query source from the drop-down menu by clicking on the arrow to the right of the field. Query sources are used to populate report definition objects with dynamic data from the database the report writer is connected to.

Note

For more information on query sources and the link between database fields and report definition objects, please see the Getting Started chapter.

Position/Size

Specify how you want the image object to be positioned and sized within the section where it is located.

X

Specify the distance, measured in inches, from the section’s left border to the upper-left-hand corner of the image object.

Width

Specify the width of the image object, measured in inches.

Y

Specify the distance, measured in inches, from the section’s top border to the upper-left-hand corner of the image object.

Height

Specify the height of the image object, measured in inches.

Tip

The position and size of a graphic object may be modified manually when editing a report definition.

Base Font

Select the base font to be used in the graph object by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects. The base font may be used throughout the graph object.

Title

Specify the following details for the graph object's title:

Title

Enter the title you want to appear centered at the top of the graph.

Use Base Font

Select to use the specified base font. If not selected, the title font will be used.

Title Font

Specify the font to be used for the graph object's title by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects.

At the bottom of the screen, the following buttons are available:

OK

Select to save your settings.

CANCEL

Closes the screen without saving any changes, returning you to the application desktop.

To define the properties of the graph object's data axis—that is, the horizontal axis running along the bottom of the Graph—select the Data Axis tab at the top of the Graph Editor screen. The following screen will appear:

Graph Editor Data Axis tab

When editing the data axis properties of a graph object, you are presented with the following options:

Data Axis Labels

Specify the following details for the data axis labels:

Column

Specify the name of the database column you want to use from the selected query source. A query source may refer to multiple columns in its SELECT statement. By indicating a specific column, you instruct the query source to return data only for that specified column. Other columns appearing in the SELECT statement will be ignored.

Note

The term data axis labels refers to the identifying information which describes each of the items in a graph’s series. For example, if a graph displays information about a series of item numbers, then data axis labels would be used to identify each of the items in the series.

Use Base Font

Select to use the specified base font. If not selected, the data axis font will be used.

Data Axis Font

Specify the font to be used for the data axis labels by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects.

Data Axis Title

Specify the following details for the data axis title:

Title

Enter the title you want to appear centered along the bottom of the graph’s data axis.

Use Base Font

Select to use the specified base font. If not selected, the data axis title font will be used.

Data Axis Title Font

Specify the font to be used for the data axis title by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects.

At the bottom of the screen, the following buttons are available:

OK

Select to save your settings.

CANCEL

Closes the screen without saving any changes, returning you to the Application desktop.

To define the properties of the graph object's value axis—that is, the vertical axis running along the left-hand side of the graph—select the Value Axis tab at the top of the Graph Editor screen. The following screen will appear:

Graph Editor Value Axis tab

When editing the value axis properties of a graph object, you are presented with the following options:

Min

Specify the minimum value you want to have appear on the graph object's value axis.

Max

Specify the maximum value you want to have appear on the graph object's value axis.

Expand Min/Max if needed

Select to allow data represented in the graph to expand beyond the minimum and maximum values specified if needed. If not selected, data will be restricted to the limits specified for the minimum and maximum values.

Use Base Font

Select to use the specified base font. If not selected, the value axis font will be used.

Value Axis Font

Specify the font to be used for values in the value axis by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects.

Value Axis Title

Specify the following details for the value axis title:

Title

Enter the title you want to appear centered along the left-hand margin of the graph’s value axis.

Use Base Font

Select to use the specified base font. If not selected, the value axis title font will be used.

Value Axis Title Font

Specify the font to be used for the value axis title by clicking on the FONT button located to the right of the field. Selecting the FONT button will bring up the Select Font screen, where you may specify font name, font style, font size, and font effects.

At the bottom of the screen, the following buttons are available:

OK

Select to save your settings.

CANCEL

Closes the screen without saving any changes, returning you to the application desktop.

To define the properties of graph object series, select the Series tab at the top of the Graph Editor screen. The following screen will appear:

Graph Editor Series tab

When editing the properties of a graph object series, you are presented with the following options:

Series

Select a series from the drop-down menu by clicking on the arrow to the right of the field. Each graph must contain at least one series—and may contain multiple series. Using multiple series enables you to compare and contrast information from different database columns within a single graph. To create a new series, select the NEW button. By default, a new series will be given the name "New Series." You may edit this default name within the Name field below. To remove a series from the list of series, select the REMOVE button.

Note

You may assign different properties to each series in a graph (e.g., different colors) to make a clear visual distinction between series.

Series Properties

Specify properties for the selected series using the following options:

Name

Displays the name of the series. You may edit the name of the series using this field. Any editing changes will be saved automatically.

Column

Specify the name of the database column you want to use from the selected query source. A query source may refer to multiple columns in its SELECT statement. By indicating a specific column, you instruct the query source to return data only for that specified column. Other columns appearing in the SELECT statement will be ignored.

Color

Specify the color you want to use to represent data in the series. Selecting the EDIT button will bring up several color definition screens. You have the ability to specify multiple colors, using either the included color wheel or standard RGB values.

Style

Specify one of the following options to be used for representing items in the series: Bars, Lines, or Points.

At the bottom of the screen, the following buttons are available:

OK

Select to save your settings.

CANCEL

Closes the screen without saving any changes, returning you to the Application desktop.