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) ASCSet 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.

Previous Steps

• First Steps

• Creating the Demo Report

• Setting the Page Header

• Creating the Table and Populating it with Data

• Creating the Graph

• Setting the Page Footer

• Integrating the Report in.NET Framework Application

• Parameterizing the Graph

Demo project

You can find the full project in our GitHub repository.

See Also

Designing reports