The type of column with name ... is not numeric

Thread is closed for posting
4 posts, 0 answers
  1. vinh le
    vinh le avatar
    2 posts
    Member since:
    Mar 2010

    Posted 07 Mar 2010 Link to this post

    When I try to make a BAR chart , I get an error message The type of column with name ... is not numeric. The data source for the chart is retrieved from SQL 2005 using this query:

    SELECT DepartmentName, COUNT(*) AS departmentSummary FROM DimEmployee GROUP BY DepartmentName

    which give me 2 coloums - one contains department name, one contains the number of employee in department name (please see attach image).





  2.
  3. Ves
    Admin
    Ves avatar
    2926 posts

    Posted 10 Mar 2010 Link to this post

    Hi vinh le,

    The screenshot shows numerous series, each one corresponding to a record in the query result. Actually, it  would be expected that ChartSeries correspond to a column where the each record's value in that column corresponds to a ChartSeriesItem. So in this case I would expect a single ChartSeries with DataYColumn set to departmentSummary. That should not trigger such error.

    Greetings,
    Ves
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  5. Vladislav Polishchuk
    Vladislav Polishchuk avatar
    3 posts
    Member since:
    May 2010

    Posted 11 Jan 2012 Link to this post

    Hello, I have same problem  for asp version of telerik report.  How I can place  string values to axisX? Thank you.
  7. Ves
    Admin
    Ves avatar
    2926 posts

    Posted 16 Jan 2012 Link to this post

    Hi Vladislav,

    When databinding the chart, you can populate the chart.PlotArea.XAxis.DataLabelsColumn property with the name of the column, which holds the strings you need to show. E.g. looking at the image attached to the initial message in this thread, the value for DataLablesColumn should be "DepartmentName".


    Kind regards,
    Ves
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now
Back to Top