Making Series Label Values invisible with a Group Data Line Radchart

Thread is closed for posting
4 posts, 0 answers
  1. Stuart Watton
    Stuart Watton avatar
    18 posts
    Member since:
    Sep 2009

    Posted 27 Jan 2011 Link to this post

    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

  2. Yavor
    Admin
    Yavor avatar
    11 posts

    Posted 01 Feb 2011 Link to this post

    Hi Stuart,

    Attached to this message, is a small application, which handles a functionality close to the one which you mentioned. I hope it gets you started properly.

    Regards,
    Yavor
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
  3. Stuart Watton
    Stuart Watton avatar
    18 posts
    Member since:
    Sep 2009

    Posted 05 Feb 2011 Link to this post

    Yavor

    Thanks for your help. I can see how I can make the values of the data points not show if I write the code to load the data as a number of series from an array or from a data source. I was hoping not to have to go to that trouble. Your functionality for column groups is great and gives the result I need in all aspects expect that the values for each data point show on the chart, and I can't get rid of them. Is there any way of stopping the values from showing, without having to loadi the data to the chart as a number of series.

    Let me know your thoughts

    Best Regards

    Stuart
  4. Yavor
    Admin
    Yavor avatar
    11 posts

    Posted 09 Feb 2011 Link to this post

    Hello Stuart,

    Basically, the Series DefaultLabelValue should be available and take effect regardless of how the control is populated. What is the behavior at your end? How is the control populated with data/series? You can open a formal support ticket, and send us a small sample, demonstrating your setup, for additional review.

    Regards,
    Yavor
    the Telerik team
    Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
Back to Top