ActiveReports 15 .NET Edition
ActiveReports 15 User Guide / How To / Page Report/RDL Report How To / Page/RDL Report Scenarios / Create a Whisker Sparkline
In This Topic
    Create a Whisker Sparkline
    In This Topic

    You can use a whisker Sparkline to render “win/loss/tie” scenarios (for example, sport statistics) or “true/false” scenarios (for example, was the sales goal met or 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, for example, in a "profit/loss/no profit, no loss" scenario.

    The following steps demonstrate how to create a whisker sparkline. These steps assume that you have already added a Page Report/RDL Report template to your project, connected it to a data source and added a dataset. See Basic Concepts, Connect to a Data Source and Add a Dataset for more information.

    Note: These steps use the AccountsChartData table from the Reels database. The Reels.mdb file can be downloaded from GitHub: ..\Samples15\Data\Reels.mdb.
    1. From the Visual Studio toolbox, drag a Sparkline control onto the design surface.
    2. With the sparkline selected on the design surface, go to the properties window and:
      • Set the Sparkline Type property to Whiskers.
      • Set the SeriesValue property to a numeric field (like =Fields!RollUp.Value) from the connected data set.
      • Set the FillStyle/FillColor property to Red.
    3. Go to the Preview tab to view the whisker sparkline.
      Whisker Sparkline
    See Also