Sparkline Control

Description

Displays a compact chart. Commonly used to illustrate the data flow for every row in a report.

Properties Common to Most Controls

For more information about the properties listed below, see Properties Common to Most Controls.

For more information regarding each of the property groups, see the Control Reference.

Actions

Data Source

Type: Object

Sets the control's data source. If left empty, the report's data source is used.

Data Member

Type: String

Specifies the data source table, which supplies data to the control.

View

Sets the type of chart used in the control. Options include the following:

Area

Bar

Line

WinLoss:

Appearance

Image Type

Specifies how the image is rendered.

Options for this property include the following:

  • Metafile: The quality of the rendered image is always good, but in particular cases, some details of the control can be lost. This is the default.
  • Bitmap: The quality of the rendered image is sometimes poor, but it allows the control to be drawn more precisely.

View

Sets the type of chart used in the control. Options include the following:

Area

Bar

Line

WinLoss:

Behavior

Anchor Vertically

Sets the location of the control in relation to the parent container. When the parent container changes size, the control may move or resize to maintain its position.

The options for vertically anchoring include:

  • None: The control's size and location are not affected when the container size changes.
  • Top: The distance between the top of the control and the top of the container remains fixed when the container size changes.
  • Bottom: The distance between the bottom of the control and the bottom of the container remains fixed when the container size changes.
  • Both: The distance from the top and bottom of the control from the top and bottom of the container remains fixed when the container size changes. This means that control is resized to maintain these fixed distances.

Anchor Horizontally

Sets the location of the control in relation to the parent container. When the parent container changes size, the control may move or resize to maintain its position.

The options for horizontally anchoring include:

  • None: When the parent container changes size, the control's size and location are not affected when the container size changes.
  • Left: The distance between the left edge of the control and the left side of the container remains fixed when the container size changes.
  • Right: The distance between the right edge of the control and the right side of the container remains fixed when the container size changes.
  • Both: The distance from the left and right edges of the control from the left and right sides of the container remains fixed when the container size changes. This means that control is resized to maintain these fixed distances.

Data

Data Source

Type: Object

Sets the control's data source. If left empty, the report's data source is used.

Data Member

Type: String

Specifies the data source table, which supplies data to the control.

Value Member

Type: String

Specifies the data source table that supplies values to the sparkline.

Value Range

The Value Range property provides access to the range of values displayed by a sparkline. This property contains a few sub-properties, which are:

Limit 1: Sets a value specifying the first limit of the range.

Limit 2: Sets a value specifying the second limit of the range.

Is Auto: When enabled, allows the value range of the sparkline to be calculated automatically.

Related Tutorials

Refer to the following resources for additional help on implementing this control: