Dynamic data set and dynamic chart

Yogesh Maharwade

Hi all,

i want to add dataset dynamically to my report based on parameter value. suppose i select three values from parameter then reports will dynamically create 3 dataset and 3 charts.

like i have 3 columns in my database table

if i select kpi-66,kpi-22 from parameter dropdownlist, i will get

kpiname selectstmt clause

kpi-66 select count(wonum) from workorder where status='CLOSE'
kpi-22 select sum(estlabhrs) from workorder here status='CLOSE'


on the basis of these two rows i want to create two data set dynamically which retrieves values from database on the basis of selectstmt,clause column.

and depends upon two dynamic column i want to add two charts dynamically.