This content has been marked as final. Show 9 replies
Thanks for responding. I need to display a table with dynamic number of columns and in the same page I need to display graphs also. Will it be possible to display? As Oracle forms supports fixed number of columns and also to display a graph I need to traverse another page for oracle report.
Can you please explain a little bit how can it be possible?
Thanks in advance.
Do you know max number of columns? If yes you can set visible = "no" dinamicaly for columns you don't need to be shown.
I developed form with 31 columns (for calendar) and managed columns in this way:
SELECT last_day(to_date(:global.p_date, 'YYYY.MM.DD')) + 1 -
FOR i IN 28 .. 31 LOOP
set_item_property('v.d' || i, visible, property_false);
FOR j IN 28 .. v_day_count LOOP
set_item_property('v.d' || j, visible, property_true);
set_item_property('v.d' || j, enabled, property_true);
<p>The Forms demo you can download from the OTN Forms page contains a bigraph sample that uses the FormsGraph.jar Java Bean. Download the zip file, then open the \demos_11g\bigraph folder.</p>