A whisker sparkline is used for rendering “win/loss/tie” (e.g. sport statistics) or “true/false” scenarios (e.g. was the sales goal met, was the temperature above average), based on the numeric data from a data set.
The bars in a whisker sparkline render below the baseline for a negative value, above the baseline for a positive value, and on the baseline for a zero value.
Before adding a sparkline to your report, you must connect your report to a data source and a data set.
- From the toolbox, drag a Sparkline item onto the body of your report.
- With the sparkline selected:
- Set the Sparkline Type property to Whiskers.
- Set the DataSetName property to a data set (e.g. DataSet1).
- Set the SeriesValue property by selecting <Expression...>. In the Expression Editor under Fields, expand the Fields (DataSet1) node and select a numeric field from the connected data set (e.g. =Fields!Value.Value). Click the OK button to accept the change.
3. You can optionally define the color of the whisker sparkline by setting the FillStyle/FillColor property to Purple.
4. Click the Preview tab to view the whisker sparkline you have added to your report.
