Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Chart > The type of column with name ... is not numeric

• vinh le

  Posted on Mar 7, 2010 (permalink)

  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).
  
  
  
  
  
  

  Attached files

  • 3-7-2010-2-38-02-pm.jpg

  Reply

• Ves Ves

  Posted on Mar 10, 2010 (permalink)

  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.

  Reply


• Vladislav Polishchuk

  Posted on Jan 11, 2012 (permalink)

  Hello, I have same problem  for asp version of telerik report.  How I can place  string values to axisX? Thank you.

  Reply

• Ves Ves

  Posted on Jan 16, 2012 (permalink)

  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

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Chart > The type of column with name ... is not numeric