Draw Sparkline Report Item

2 Jun 20212 minutes to read

You can add a sparkline to the Report Designer using the following steps.

  1. Click sparkline in the Insert Tab and drag it to the Report designer.

    Draw-Sparkline-Report-Item_images1

  2. A Chart properties wizard opens, Click Ok.Then sparkline will be added with its default properties.

    Draw-Sparkline-Report-Item_images2

  3. To Add the Report Items such as text boxes, lines, and images and rectangle to the sparkline,click and drag the selected report items to the sparkline.

    Draw-Sparkline-Report-Item_images3

  4. To Apply Styles to the sparkline, Right Click on the sparkline and select the Chart Properties from the context menu or click on the view report item properties.

    Draw-Sparkline-Report-Item_images4

    Draw-Sparkline-Report-Item_images5

  5. In the Chart Properties dialog, select any of the following.

    Draw-Sparkline-Report-Item_images6

    • General - To change the sparkline type and ToolTip of the chart.

    • Data - To set the Dataset name and data fields of the corresponding datasets.

    • Appearance - To set the Chart name and border options and background options.

  6. Click Ok.Then the values are updated in the sparkline.

  7. Select properties like chart title, axis title, grid lines, axis and add chart in x axis, y axis and series in Layout tab.

    Draw-Sparkline-Report-Item_images7

  8. To convert the sparkline to chart, Right click on the sparkline and select convert to full chart.

    Draw-Sparkline-Report-Item_images8

  9. Then the sparkline will converted into the chart.

    Draw-Sparkline-Report-Item_images9

  10. To delete the sparkline, right click and select delete.

    Draw-Sparkline-Report-Item_images10

    Draw-Sparkline-Report-Item_images11