Telerik is a leading vendor of ASP.NET AJAX, ASP.NET MVC, Silverlight, WinForms and WPF controls and components, as well as .NET Reporting, .NET ORM , .NET CMS, Code Analysis, Mocking, Team Productivity and Automated Testing Tools. Building on its expertise in interface development and Microsoft technologies, Telerik helps customers build applications with unparalleled richness, responsiveness and interactivity. Telerik products help thousands of companies to be more productive and deliver reliable applications under budget and on time.
Version Q1 2012 released 04/11/2012
select
  • Rate / Review ▼

    • Give your Feedback:

      Rate this demo:


Chart / Drill-down chart

DrillDown RadChart

Did you know that you can add Telerik Silverlight Charts to your ASP.NET applications?

RadControls for Silverlight


  • The example shows how the drill down functionality of the chart can be used. On the first chart the data is grouped by the greatest time span, which is year. The year is divided into quarters. By clicking on an item on the chart you can see the values correspoding to the quarters of the selected year. Each quarter consists of 3 months. After choosing a quarter for the selected year you can see the values for each month of the this quarter.

Source Code

C# VB.NET
Show code in new window Demo isolation steps
  • <%@ Page Language="C#" AutoEventWireup="true" CodeFile="DefaultCS.aspx.cs" Inherits="Chart.Examples.Functionality.DrillDown.DefaultCS" %>

    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
    <%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Charting" TagPrefix="telerik" %>

    <%@ Register TagPrefix="telerik" TagName="Footer" Src="~/Common/Footer.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="HeadTag" Src="~/Common/HeadTag.ascx" %>
    <%@ Register TagPrefix="telerik" TagName="Header" Src="~/Common/Header.ascx" %>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head id="Head1" runat="server">
        <telerik:HeadTag runat="server" ID="Headtag1"></telerik:HeadTag>
        <style type="text/css">area{outline:0;}</style>
        <!-- custom head section -->
        <!-- end of custom head section -->
    </head>
    <body class="BODY">
        <form id="Form1" runat="server">
            <telerik:Header ShowSkinChooser="false" runat="server" ID="Header1" NavigationLanguage="C#"></telerik:Header>
            <!-- content start -->
            <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
            <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                <AjaxSettings>
                    <telerik:AjaxSetting AjaxControlID="RadChart1">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadChart1" LoadingPanelID="LoadingPanel1" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                    <telerik:AjaxSetting AjaxControlID="Refresh">
                        <UpdatedControls>
                            <telerik:AjaxUpdatedControl ControlID="RadChart1" LoadingPanelID="LoadingPanel1" />
                            <telerik:AjaxUpdatedControl ControlID="Refresh" />
                        </UpdatedControls>
                    </telerik:AjaxSetting>
                </AjaxSettings>
            </telerik:RadAjaxManager>
            <telerik:RadChart ID="RadChart1" runat="server" OnClick="RadChart1_Click" OnPrePaint="RadChart1_PrePaint" DataSourceID="SqlDataSource1"
                AlternateText="DrillDown RadChart" Skin="Office2007" >
                <ChartTitle>
                    <TextBlock Text="Revenue">
                    </TextBlock>
                </ChartTitle>
                <Series>
                    <telerik:ChartSeries DataXColumn="Year" DataYColumn="Rev" Name="Years">
                    </telerik:ChartSeries>
                </Series>
                <PlotArea>
                    <Appearance Dimensions-Margins="19%, 90px, 12%, 12%">
                    </Appearance>
                    <XAxis MaxValue="2005" IsZeroBased="False" DataLabelsColumn="Year" AutoScale="False"
                        MinValue="2003" Step="1">
                        <Items>
                            <telerik:ChartAxisItem Value="2003">
                            </telerik:ChartAxisItem>
                            <telerik:ChartAxisItem Value="2004">
                            </telerik:ChartAxisItem>
                            <telerik:ChartAxisItem Value="2005">
                            </telerik:ChartAxisItem>
                        </Items>
                    </XAxis>
                </PlotArea>
            </telerik:RadChart>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>" SelectCommand="SELECT Sum(Revenue) as Rev, Year FROM Revenue GROUP BY Year"></asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
                SelectCommand="SELECT Sum(Revenue) as Rev, Quarter FROM Revenue WHERE Year=@Year GROUP BY Quarter">
                <SelectParameters>
                    <asp:Parameter Name="Year" />
                </SelectParameters>
            </asp:SqlDataSource>
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:TelerikConnectionString %>"
                SelectCommand="SELECT Sum(Revenue) as Rev, Month FROM Revenue WHERE Year=@Year AND Quarter = @Quarter GROUP BY Month">
                <SelectParameters>
                    <asp:Parameter Name="Year" />
                    <asp:Parameter Name="Quarter" />
                </SelectParameters>
            </asp:SqlDataSource>
            <telerik:RadAjaxLoadingPanel ID="LoadingPanel1" Height="77px" Width="113px" runat="server" >
            </telerik:RadAjaxLoadingPanel>
            <br/>
            <asp:Button runat="server" ID="Refresh" Text="Initialize Chart" CssClass="qsfButtonBig" OnClick="Refresh_Click" />
            <!-- content end -->
            <telerik:Footer ShowCodeViewer="true" runat="server" ID="Footer1"></telerik:Footer>
        </form>
    </body>
    </html>

Get more than expected!

Take your time to truly experience the power of RadControls for ASP.NET AJAX with a free 60-day trial backed up by Telerik’s unlimited dedicated support.

Download your RadControls for ASP.NET AJAX trial and jumpstart your development with the available Getting Started resources.

If you have any questions, do not hesitate to contact us at sales@telerik.com.

Copyright 2002-2012 © Telerik. All right reserved
Telerik Inc, 201 Jones Rd, Waltham, MA 02451