Sparkline report control is a simple means of displaying the trend of data in a small graph. It displays the most recent value as the rightmost data point and compares it with earlier values on a scale, allowing you to view general changes in data over time. With the height similar to the surrounding text, you can display data either using line, columns, whiskers, area, or stacked bar sparkline types.
Some properties of the Sparkline control are described below. Note that you need to enable Advanced Properties Mode to view all properties.
Sparkline Type: Choose from the following options.
Name: Enter a name for the group that is unique within the report. This property cannot be set until after a Group expression is supplied. You can only use underscore (_) as a special character in the Name field. Other special characters such as period (.), space ( ), forward slash (/
), back slash (\
), exclamation (!), and hyphen (-) are not supported.
Group Expressions: Enter an expression to use for grouping the data.
Parent: Enter an expression to use as the parent group. This is for use in case of recursive hierarchies.
Label: Enter an expression to use as a label to represent this item for the document map and search functions.
Line Color: Select a color to use for the line from Color Picker, Standard Colors, or Web Colors.
Line Width: Enter a value in points to set the width of the line.
Marker Color: Select a color to use for the last point marker from Color Picker, Standard Colors, or Web Colors.
Marker Visibility: Select whether to display a marker at the last point on the sparkline of Line type.
Maximum Width: Select the maximum width of columns in the sparkline. If blank, all columns are sized to fit.
Fill Color: Select a color to fill the sparkline.
Gradient Type: Choose the type of gradient for the sparkline from these options: None, LeftRight, TopBottom, Center, DiagonalLeft, DiagonalRight, HorizontalCenter or VerticalCenter.
Gradient End Color: Select a color to use for the end of the sparkline gradient.
Lower Bound: Select a value or enter an expression that defines the lower bound of the range.
Upper Bound: Select a value or enter an expression that defines the upper bound of the range.
Fill Color: Select a color to use for the sparkline range. The range is a colored rectangle to determine the lowest and highest levels acceptable values.
Gradient Type: Choose the type of gradient for the range from these options: None, LeftRight, TopBottom, Center, DiagonalLeft, DiagonalRight, HorizontalCenter or VerticalCenter.
Gradient End Color: Select a color to use for the end of the range gradient.
Data Set Name: Select a dataset to associate with the sparkline. The drop-down list is populated with all of the datasets in the report's dataset collection.
Sort Expressions: In the Expression box, enter an expression by which to sort the data, and under Direction, select Ascending or Descending for the selected sort expression.
Filters: You need to provide following values to add a new filter to the collection:
Filter Expression: Enter the expression to use for evaluating whether data should be included in the group.
Operator: Select from the following operators to decide how to compare the expression to the left with the value to the right.
Value: Enter a value to compare with the expression on the left based on the selected operator. For multiple values used with the Between operator, the lower two value boxes are enabled.
Filter Values: When you choose the In operator, you can enter as many values as you need in this list.
Submit and view feedback for