2 Replies Latest reply: Feb 17, 2010 11:07 PM by user518248 RSS

    BI GRAPHS IN ORACLE FORMS 10G

    user518248
      AFTER FINDING SOLUTION TO MAKE GRAPHS CUSTOMIZATION IN ORACLE FORMS 10G, I was suggested to use BIGRAPH so installed all package(formsgraph.jar and whole demo package) and I configured properly all my files. But graph.fmx which exist in demo when run on browser does not display any graph on bean area it might be as no data retreived or data not populated due to bug in fmb . I made new temp.fmb by only creating single item and bean on canvas. On validating item I wrote following syntax.


      BEGIN
           
           IF (:BLOCK1.TEXT_ITEM5 = ' ') THEN
           message('validating');     
           set_custom_property('block1.BeanArea1',1,'GRAPHTYPE','HORIZONTAL_BAR');
      set_custom_property('block1.BeanArea1',1,'ENABLE_TOOLTIPS','ALL');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'SET_DELIMITER',',');


      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','Europe,Sales,25000');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','USA,Sales,70000');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','Europe,Taxes,2500');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','USA,Taxes,2500');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','Europe,Savings,22500');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','USA,Savings,67500');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_DATA_TO_GRAPH','');
      SET_CUSTOM_PROPERTY('block1.BeanArea1',1,'ADD_ROWDATA','UK,Taxes,67500');


      set_custom_property('block1.BeanArea1',1,'SHOW_GRAPH','');
                          
           END IF;
      END;


      Still surprise as forms open successfully on Web browser but no chart displayed. I am really fade up as I required lot of time to install demo version in my original oracle 10g software. My boss say how can new version have no features of graphics. I can not tell or say to buy that oracle graphics are customized in Oracle 11g.

      If anybody have solution for above, please reply.
      Thanks,
      Prashant