This is a migrated thread and some comments may be shown as answers.

Multiple series from multiple tables

2 Answers 107 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
mike
Top achievements
Rank 1
mike asked on 08 Sep 2008, 03:05 PM
Hi
Just wondering if there is some way of having each of my data series from a separate data table within a single dataset. I have tried creating two series, and then returning data from a database in two different tables (but within the same dataset), and the RadChart seems to ignore the second table completely. If all the data must be in a single table, this makes it extremely difficult to return the data as I need to dynamically create tables in SQL with different numbers of columns, and union all my data results into a single table, which also wastes a lot of bandwidth as I would have a lot of null value columns because each series of data must include nulls for all the values from the other series.
Thanks

2 Answers, 1 is accepted

Sort by
0
Accepted
Ves
Telerik team
answered on 09 Sep 2008, 05:44 AM
Hi Mike,

I am afraid you cannot show data from different tables in RadChart using databinding. Still, you can create manually the series you need to show and add ChartSeriesItems to them according to the values in the different tables. You can find examples of programmatically created RadChart here and here (help topics) and in this online example.

Hope this helps.

Greetings,
Ves
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
mike
Top achievements
Rank 1
answered on 09 Sep 2008, 08:13 AM
Thanks, that workaround should do the trick.
Tags
Chart (Obsolete)
Asked by
mike
Top achievements
Rank 1
Answers by
Ves
Telerik team
mike
Top achievements
Rank 1
Share this question
or