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, where 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 data set i want to add two charts dynamically.

Yogesh Maharwade

Hi all,

if anybody knows about maximo, there is table kpimain, contains column kpiname, selectstmt, clause.

on the basis of kpimain table i am trying to generate dataset and charts dynamically.



piwya