Progress® Telerik® Reporting R3 2021

New to Telerik Reporting? Download free 30-day trial

How to Add Column Graph

This article is part of the Demo report guide on getting started with Telerik Reporting and demonstrates how to add a new graph which will display the top five stores per year and per quarter.

  1. Click on the Report Header section and then go to Insert > Bar > Clustered Bar to add the new graph next to the pie chart.

  2. From Graph Wizard, use the graphDataSource, then drag StoreName to Categories, OrderDate to Series, and Sum(LineTotal) to Values.

  3. Sort and filter the series groups and the category groups. You can also set specific colors through the Color palette option.

    Set the series groups in the folowing way:

    • Grouping: =Quarter(Fields.OrderDate)

    • Sorting: =Quarter(Fields.OrderDate) ASC

    Set the cetagories grpups in the following way:

    • Filtering:

      • Expression: =Sum(Fields.LineTotal)

      • Operator: Top N

      • Value: =5

    • Sorting: =Quarter(Fields.OrderDate) ASC

Previewing the Result

Preview the result by clicking Preview > PrintPreview.

FinalGS

Previous Steps

Demo project

You can find the full project in our GitHub repository.

See Also

In this article
Not finding the help you need?