Wyn Enterprise User Guide

Wyn Enterprise: Sparkline

In Wyn Enterprise, the Sparkline control is used to display data trends on a small graph in your reports. Sparkline shows the most recent value of the data at the rightmost point and compares it with an earlier value, allowing you to view general changes in the data over time. Sparkline control supports line, column, profit and loss, area, and stacked charts. Sparkline control can be embedded within tables for better understanding and analysis of business data.

Structure

Structure of the Sparkline control

  • Series Value: A series value is used to show a set of data in the sparkline chart.
  • Grouping Expressions: Grouping expressions are used to group data in the sparkline.

To add a Sparkline control to a report, navigate to the Report Designer and follow the below instructions:

  1. Drag and drop the Sparkline control onto the design area from the Designer Toolbar.
    Drag and drop the sparkline control on design area

  2. Using the Inspector Panel on the right side of your screen, customize the appearance of the Sparkline control. See the Inspector Panel Properties section for more information on the properties of the Sparkline control. Inspector Panel properties of Sparkline

Inspector Panel Properties

Common

Property Description
Name Add a unique name to the Sparkline control. Special characters such as period (.), space ( ), forward slash (/), backslash (\), exclamation marks (!), and hyphens (-) are not supported. You can use an underscore (_) in the name of the control.
Sparkline Type Select the chart type for the sparkline control. Use the dropdown to select one of the following options:
Line, Columns, Whiskers, Area, or StackedBar.
Series Value Enter a value or an expression to use as a series value for the sparkline control.

Dimensions

Property Description
Left Set the left margin of the Sparkline control.
Top Set the top margin of the Sparkline control.
Width Set the width of the Sparkline control.
Height Set the height of the Sparkline control.

Layout

Property Description
Style Select a color theme for the Sparkline control from the dropdown.

Group

Property Description
Name Add a unique name to the details group. Special characters such as period (.), space, ( ), forward slash (/), backslash (\), exclamation marks (!), and hyphens (-) are not supported. You can use an underscore (_) in the name of the group.
Group Expression Add grouping expressions, such as field names, to the sparkline control using the + button.

Data

Property Description
Data Set Name Select a dataset from the dropdown to bind the data to the sparkline control.
Data Set Parameters Add parameters to the dataset using the + button. Dataset parameters can be values or expressions.
Sort Expressions Set a sort expression for the sparkline control using this property. See the Sort Data help article for more information.
Filters Add filters to filter out the data from the report. See the Filter Data help article for more information.