or
CREATE PROCEDURE GetSalesValueASSELECT DATENAME(mm, Sales.SaleOrderDate) AS MonthOfSale , SUM(Quotes.NETPrice) AS SalesValue , Source.SourceFROM Quotes INNER JOIN Sales ON Quotes.QuoteId = Sales.QuoteId INNER JOIN Enquiry ON Quotes.EnquiryId = Enquiry.EnquiryId INNER JOIN Source ON Enquiry.SourceId = Source.SourceIdGROUP BY Sales.SaleOrderDate, Year(Sales.SaleOrderDate), Source.Sourceprivate void PositionTempChartNeedDataSource(object sender, EventArgs e){PositionTempChart.DataSource = this.DataSource;var procChart = (Telerik.Reporting.Processing.Chart)sender;var defChart = (Telerik.Reporting.Chart)procChart.ItemDefinition;defChart.IntelligentLabelsEnabled = false;defChart.PlotArea.Appearance.Dimensions.Margins.Top = Unit.Pixel(25);defChart.PlotArea.Appearance.Dimensions.Margins.Bottom = Unit.Pixel(25);defChart.PlotArea.Appearance.Dimensions.Margins.Left = Unit.Pixel(25);defChart.PlotArea.Appearance.Dimensions.Margins.Right = Unit.Pixel(0); var temperature1 = new ChartSeries { Type = ChartSeriesType.Line };temperature1.Clear();temperature1.DataYColumn = "Temp1";temperature1.DataXColumn = "DoubleDateTime";temperature1.Appearance.ShowLabels = false;temperature1.Appearance.LineSeriesAppearance.Color = System.Drawing.ColorTranslator.FromHtml("#86D8A0");temperature1.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.Nothing;defChart.Series.Add(temperature1);var temperature2 = new ChartSeries { Type = ChartSeriesType.Line };temperature2.Clear();temperature2.DataYColumn = "Temp2";temperature2.DataXColumn = "DoubleDateTime";temperature2.Appearance.ShowLabels = false;temperature2.Appearance.LineSeriesAppearance.Color = System.Drawing.ColorTranslator.FromHtml("#F09081");temperature2.Appearance.LegendDisplayMode = ChartSeriesLegendDisplayMode.Nothing;defChart.Series.Add(temperature2);defChart.PlotArea.XAxis.DataLabelsColumn = "DoubleDateTime";defChart.PlotArea.XAxis.IsZeroBased = false;defChart.PlotArea.XAxis.AutoScale = false;defChart.PlotArea.XAxis.Appearance.ValueFormat = ChartValueFormat.ShortTime;defChart.PlotArea.XAxis.Appearance.CustomFormat = "HH";}