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).
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).
3 Answers, 1 is accepted
0
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.
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.
0
Vladislav Polishchuk
Top achievements
Rank 1
Rank 1
answered on 11 Jan 2012, 10:44 AM
Hello, I have same problem for asp version of telerik report. How I can place string values to axisX? Thank you.
0
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
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