mardi 10 avril 2012

Create Graph and load data to graph using axapta

void createGraph1()
{
//SalesLine salesline;
LedgerBudget ledgerBudget;

int i,k;
str month;
// date createddate;
#macrolib.ChartFx
;

graphics1 = Graphics::newGraphicsTitlesLayout(ChartX1, 100, 200,'Title', 'X', 'Y', 'z',1 ,1, 1, 1);
graphics1.create();
graphics1.parmTitle("MonthWise Comparison(G)");
graphics1.parmTitleXAxis('Month');
graphics1.parmTitleYAxis('Amount');
ChartX1.Chart3D(true);
ChartX1.toolBar(true);
//graphics.Gallery(9);
graphics1.parmHeight(350);
graphics1.parmWidth(450);

AllocApr=0;
AllocMay=0;
AllocJun=0;
AllocJul=0;
AllocAug=0;
AllocSept=0;
AllocOct=0;
AllocNov=0;
AllocDec=0;
AllocJan=0;
AllocFeb=0;
AllocMar=0;
while select * from LedgerBudget where LedgerBudget.Key!="" //ledgerBudget.AccountNum==ledgerTable.AccountNum
{
// DivisionName=divnm;

// if (salesline.createdDate >= fromDate &&
// salesline.createdDate <= toDate) // { //switch(strFmt('%1',MthOfYr(LedgerJournalTable::find(ledgerJournalTrans.JournalNum).PostedDate))) switch(strFmt('%1',MthOfYr( LedgerBudget.createdDate)))

case '4': // info(strFmt('%1 %2', Year(_date), MthOfYr(_date) )); AllocApr += LedgerBudget.Amount; break; case '5': AllocMay += LedgerBudget.Amount; break; case '6': 
AllocJun += LedgerBudget.Amount; break; case '7': AllocJul += LedgerBudget.Amount; break; case '8': AllocAug += LedgerBudget.Amount; break; case '9': AllocSept += LedgerBudget.Amount; break; case '10': AllocOct += LedgerBudget.Amount; break; case '11': AllocNov += LedgerBudget.Amount; break; case '12': AllocDec += LedgerBudget.Amount; break; case '1': AllocJan += LedgerBudget.Amount; break; case '2': AllocFeb += LedgerBudget.Amount; break; case '3': AllocMar += LedgerBudget.Amount; break; } } for (k=0;k<12;k++) { if (k==0) { // if(AllocJan!=0) 
{
 graphics1.loadData("Jan","",AllocJan); } } if (k==1) { // if(AllocFeb!=0) { graphics1.loadData("Feb","",AllocFeb); } } if (k==2) { // if(AllocMar!=0) { graphics1.loadData("Mar","",AllocMar); } } if (k==3) { // if(AllocApr!=0) { graphics1.loadData("Apr","",AllocApr); } }
 if (k==4) 
{ // if(AllocMay!=0) { graphics1.loadData("May","",AllocMay); } } if (k==5) { // if(AllocJun!=0) { graphics1.loadData("Jun","",AllocJun); } } if (k==6) { 
// if(AllocJul!=0) { graphics1.loadData("Jul","",AllocJul); 
} } if (k==7) { // if(AllocAug!=0) { graphics1.loadData("Aug","",AllocAug); } }
 if (k==8) { // if(AllocSept!=0) { graphics1.loadData("Sept","",AllocSept); } }
 if (k==9)
 { // if(AllocOct!=0) { graphics1.loadData("Oct","",AllocOct); } } if (k==10) { // if(AllocNov!=0) { graphics1.loadData("Nov","",AllocNov); } } if (k==11) { // if(AllocDec!=0) { graphics1.loadData("Dec","",AllocDec); } } } graphics1.showGraph(); }

Aucun commentaire:

Enregistrer un commentaire