This entire dynamic, database driven, multiple series drill down was created with less than 10 (Ten!) lines of ASP.NET code. |
Chart.DateGrouping =
TimeInterval.Years; Chart.DrillDownChain="Years,Quarters,Months,days=Days,hours,minutes"; Chart.DefaultSeries.ConnectionString = @"temp/chartsample.mdb"); Chart.Series.SqlStatement= @"SELECT OrderDate,Sum(Quantity),Name FROM Orders WHERE OrderDate >= #STARTDATE# AND OrderDate <= #ENDDATE# GROUP BY Orders.OrderDate,Name ORDER BY Orders.OrderDate"; Chart.Series.Name="Items 1"; Chart.Series.StartDate=new System.DateTime(2002,1,1,0,0,0); Chart.Series.EndDate = new System.DateTime(2002,12,31,23,59,59); Chart.SeriesCollection.Add(); |