Add Sparklines to a Report

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Dashboards and Reports Customization Guide > Designing Reports > Use Report Elements > Use Gauges and Sparklines 

Add Sparklines to a Report

Sparkline Overview

The Sparkline control displays a compact chart that is commonly used to illustrate the data flow for every row in a report.

 

To add this control to the report, drag the Sparkline item from the Toolbox and drop it onto the report.

 

eurd-web-add-sparkline-control-to-report

 

Bind the Sparkline to Data

You can connect the sparkline to individual data without accessing a report's data source. Click the Data Source property's drop-down list and select the required data source.

 

eurd-web-sparkline-select-data-source

 

The sparkline uses the report's data source if you do not specify the DataSource property.

 

After that, specify the Data Member property and set the Value Member property to a data field that provides point values for the sparkline.

 

To create a new data source for a sparkline, click Add Data Source... and bind the required data source.

 

Adjust the Sparkline View

The sparkline supports the Line, Area, Bar and WinLoss view types.

 

The View property provides access to options that change the sparkline's appearance.

 

eurd-web-sparkline-view-property

 

Each view type has properties that define the extreme values' visibility:

 

Highlight Start Point and Highlight End Point;

Highlight Min Point and Highlight Max Point.

 

Specific properties differ between view types, such as the Highlight Negative Points setting that is available only for the Bar sparkline.

 

The following image illustrates a table report containing sparklines that provide maximum and minimum value indicators in their data range:

 

eurd-web-report-with-sparklines