Hello,
I am new to using the chart and was looking at the demos. On one of them they are using a SQLDataSource control using a select statement to select the x/y series data. It looked like the fields selected are being used in the series code to define the data fields. My question is if I use a stored procedure that returns many extra fields can I still use it and only set the fields I want for the series part? In other words if I have fields Sales, ID, Person, Address, City returned and I only want to use Sales and Person can I do this and it will ignore the other fields being returned?
Thanks!
Warren
I am new to using the chart and was looking at the demos. On one of them they are using a SQLDataSource control using a select statement to select the x/y series data. It looked like the fields selected are being used in the series code to define the data fields. My question is if I use a stored procedure that returns many extra fields can I still use it and only set the fields I want for the series part? In other words if I have fields Sales, ID, Person, Address, City returned and I only want to use Sales and Person can I do this and it will ignore the other fields being returned?
Thanks!
Warren
1 Answer, 1 is accepted
0
Hi Warren,
Sure, you can use an existing stored procedure as long as it provides the necessary data. Having more columns will not hurt. Make sure that you populate correctly the ChartSeries' properties that define ChartSeriesItems' values -- DataLabelsColumn, DataXColumn, DataYColumn, DataXColumn2, DataYColumn2, DataYColumn3 and DataYColumn4 (use only those that are relevant for your series).
As a side note, RadChart is not in active development and for new development we recommend using our RadHtmlChart. You can find a detailed comparison here.
Best regards,
Ves
Telerik
Sure, you can use an existing stored procedure as long as it provides the necessary data. Having more columns will not hurt. Make sure that you populate correctly the ChartSeries' properties that define ChartSeriesItems' values -- DataLabelsColumn, DataXColumn, DataYColumn, DataXColumn2, DataYColumn2, DataYColumn3 and DataYColumn4 (use only those that are relevant for your series).
As a side note, RadChart is not in active development and for new development we recommend using our RadHtmlChart. You can find a detailed comparison here.
Best regards,
Ves
Telerik
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 the blog feed now.