If you want to Load data to show as a chart in axapta then you need to drag chart control to form group or tab then you can store data in to tables. You can use while loop to take data in looping and at the time of loop execution you can call data to graph.
This is a simple method which you can call on init method of form to show data initially.
This is a simple method which you can call on init method of form to show data initially.
void createGraph()
{
//SalesLine salesline;
// graphics graphics,graphics1;
int i,k;
str month;
// date createddate;
#macrolib.ChartFx
;
graphics1 = Graphics::newGraphicsTitlesLayout(ChartX, 100, 200,'Title', 'X', 'Y', 'z',1 ,1, 1, 1);
graphics1.create();
graphics1.parmTitle("");
graphics1.parmTitleXAxis('Year');
graphics1.parmTitleYAxis('Weight(Kg.)');
ChartX.Chart3D(true);
ChartX.toolBar(true);
//graphics.Gallery(9);
ChartX.Gallery(6);
ChartX.DataEditor(true);
ChartX.grid(1);
ChartX.BackColor(16777215);
ChartX.ToolBar(true);
ChartX.ContextMenus(true);
graphics1.parmHeight(450);
graphics1.parmWidth(350);
ChartX.WallWidth(1);
//ChartX.AxesStyle(2);
// ChartX.MarkerSize(1);
ChartX.MenuBar(true);
//ChartX.MultipleColors(true);
ChartX.RightGap(10);
ChartX.LeftGap(1);
ChartX.RecalcScale();
// ChartX.AxisX().LabelAngle(0);
// ChartX.SerLegBox(0);
while select Limits order by Limits.RecId
{
/* graphics1.loadData(int2str(Limits.srno),"Limit1",str2int(Limits.Limit1));
graphics1.loadData(int2str(Limits.srno),"Limit2",str2int(Limits.Limit2));
graphics1.loadData(int2str(Limits.srno),"Limit3",str2int(Limits.Limit3));*/
graphics1.loadData(Limits.Position,"Limit1",str2int(Limits.Limit1));
graphics1.loadData(Limits.Position,"Limit2",str2int(Limits.Limit2));
graphics1.loadData(Limits.Position,"Limit3",str2int(Limits.Limit3));
}
while select ChildData1 order by ChildData1.RecId
{
dt1=str2date(ChildData1.BirthDate,123);
dt2=str2date(ChildData1.Date,123);
sy1=date2str(dt1,123, 2, 4, 2, 4, 4);
sy2=date2str(dt2,123, 2, 4, 2, 4, 4);
y1=str2int(substr(sy1, 4, 2));
y2=str2int(substr(sy2, 4, 2));
y=y2-y1;
graphics1.loadData(ChildData1.Position,"Child",str2int(ChildData1.Weight));
}
graphics1.showGraph();
}