How to pass elements of Data set in Array

Shilpa

Hello,

I need to take elements from DB and need to make Flash Pie Charts accordingly.Example, if there are 5 records in DB then I shld be able to make 5 Pie charts for each element ,if there are 6 elements then 6 charts accordingly.

So Can anybdy help
1) How to take elements of data set of a column in to some Array or list so that I can use that list ?If i take row["test"],it will give current row only

2) How can I make charts dynamically ?


Regards
Shilpa

CBR

My suggestion would be not to create the charts dynamically but to use a table element instead.
So you first create a dataset that runs your query against the DB and returns as many rows as chart should be generated. Now you put a table inside your report that's bound to that dataset. You can now just put one chart element inside the detail row of that table. Because the dataset the table is bound to returns 5 records the chart will be generated 5 times (one chart per record).