Quickly create a basic Graph/ Chart

rem On the peoplesoft page, first get the chart control and associate it to a work record field;

&oChart2 = GetChart();
&oChart2.Reset();
&myrowset = CreateRowset(Record.);

rem fill this rowset using fill method or copyrowset from a rowset already loaded into the buffer memory;

&NumArray = CreateArray(1, 10, 12, 9);
rem this is for different colors that will be used in the graph;
&oChart2.SetColorArray(&NumArray);

&oChart2.XAxisScaleResolution = %ChartAxisResolution_Coarse;
&oChart2.YAxisScaleResolution = %ChartAxisResolution_Coarse;
&oChart2.SetData(&myrowset);
&oChart2.SetDataXAxis(Myrecord.fld1);
&oChart2.SetDataYAxis(Myrecord.fld2);
&oChart2.XAxisLabelOrient = %ChartText_Vertical;
&oChart2.Type = %ChartType_2DBar;

No comments:

Post a Comment