Hi
I have created a Radchart successfuly using the following code
Dim sqlDataSource As New SqlDataSource()
sqlDataSource.ID = "myDataSource"
sqlDataSource.ConnectionString = "data source=" & Session("Server").ToString & "; initial catalog=" & Session("Database").ToString & "; Connect Timeout=5000; " & System.Configuration.ConfigurationManager.AppSettings("Credentials")
sqlDataSource.SelectCommand = "SELECT rtrim(substring([partnumber],patindex('%-%',partnumber) + 1, 50)) AS Location ,[wt101 Customer Calender].[Date] AS Date ,isnull(sum([BufferInventory]),0) AS Buffer FROM [wt273FEPGroupResults] INNER JOIN [wt101 Customer Calender] ON [wt273FEPGroupResults].[Date] = [wt101 Customer Calender].[Date] WHERE [wt101 Customer Calender].[Date] >= (select min(date) from [wt273FEPGroupResults] where [item] = '" & RTrim(txtItem.Text) & "') and [wt101 Customer Calender].[Date] <= (select max(date) from [wt273FEPGroupResults] where [item] = '" & RTrim(txtItem.Text) & "') and [item] = '" & RTrim(txtItem.Text) & "' GROUP BY rtrim(substring([partnumber],patindex('%-%',partnumber) + 1, 50)),[wt101 Customer Calender].[Date] ORDER BY [Location],[Date]"
Me.Page.Controls.Add(sqlDataSource)
radChart1.DataGroupColumn = "Location"
radChart1.PlotArea.XAxis.DataLabelsColumn = "Date"
radChart1.Legend.Appearance.GroupNameFormat = "#NAME: #VALUE"
radChart1.SeriesOrientation = ChartSeriesOrientation.Vertical
radChart1.DefaultType = ChartSeriesType.Line
radChart1.DataSourceID = "myDataSource"
radChart1.ChartTitle.TextBlock.Text = "Buffer Inventory by Location"
radChart1.PlotArea.XAxis.AutoScale = True
radChart1.DataBind()
All very straight forwards. The problem I have is that the chart shows the value of each data point on the chart.
Is there any way to get rid of these values and just show the lines?
Thanks in Advance
I have created a Radchart successfuly using the following code
Dim sqlDataSource As New SqlDataSource()
sqlDataSource.ID = "myDataSource"
sqlDataSource.ConnectionString = "data source=" & Session("Server").ToString & "; initial catalog=" & Session("Database").ToString & "; Connect Timeout=5000; " & System.Configuration.ConfigurationManager.AppSettings("Credentials")
sqlDataSource.SelectCommand = "SELECT rtrim(substring([partnumber],patindex('%-%',partnumber) + 1, 50)) AS Location ,[wt101 Customer Calender].[Date] AS Date ,isnull(sum([BufferInventory]),0) AS Buffer FROM [wt273FEPGroupResults] INNER JOIN [wt101 Customer Calender] ON [wt273FEPGroupResults].[Date] = [wt101 Customer Calender].[Date] WHERE [wt101 Customer Calender].[Date] >= (select min(date) from [wt273FEPGroupResults] where [item] = '" & RTrim(txtItem.Text) & "') and [wt101 Customer Calender].[Date] <= (select max(date) from [wt273FEPGroupResults] where [item] = '" & RTrim(txtItem.Text) & "') and [item] = '" & RTrim(txtItem.Text) & "' GROUP BY rtrim(substring([partnumber],patindex('%-%',partnumber) + 1, 50)),[wt101 Customer Calender].[Date] ORDER BY [Location],[Date]"
Me.Page.Controls.Add(sqlDataSource)
radChart1.DataGroupColumn = "Location"
radChart1.PlotArea.XAxis.DataLabelsColumn = "Date"
radChart1.Legend.Appearance.GroupNameFormat = "#NAME: #VALUE"
radChart1.SeriesOrientation = ChartSeriesOrientation.Vertical
radChart1.DefaultType = ChartSeriesType.Line
radChart1.DataSourceID = "myDataSource"
radChart1.ChartTitle.TextBlock.Text = "Buffer Inventory by Location"
radChart1.PlotArea.XAxis.AutoScale = True
radChart1.DataBind()
All very straight forwards. The problem I have is that the chart shows the value of each data point on the chart.
Is there any way to get rid of these values and just show the lines?
Thanks in Advance