1 Reply Latest reply: Sep 10, 2009 11:47 AM by 134038 RSS

    BI Graph Showing decimal values

    134038
      Hi,

      I downloaded the biGraph demo (including the patch) and using it with Forms 10g (10.1.2.3.0). It is working except that the query returns decimal values and the graph (vertical bar) is only showing columns with integer values. To show all the columns, I had to round off the decimal values. Is there any way to get the graph to show decimal values?

      Edited by: stevemax on Sep 9, 2009 5:07 PM
        • 1. Re: BI Graph Showing decimal values
          134038
          I have figured out my problem. I was using a string value to store the contents for the ADD_ROWDATA and the decimal values were converted to integers because I was not using a to_char. By using the to_char around the value the problem was solved.

               set_custom_property('apps1.workload',1,'CLEAR_GRAPH','');
          for v_rec in c_workload(v_apps, v_apps2, v_apps3, v_suf_cd) loop
               v_data := v_rec.gLabel||bigraph.g_delim||v_rec.gLabel||bigraph.g_delim||*to_char(v_rec.gValue,'999.9');*
               set_custom_property('apps1.workload',1,'ADD_ROWDATA',v_data);
          end loop;
               set_custom_property('apps1.workload',1,'ADD_DATA_TO_GRAPH','');