Skip to main content

Create Graph and load data to graph using MSD 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::findledgerJournalTrans.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();  
 }  

Popular posts from this blog

strScan and Find a first occurrence of a string in a string using x++

strScan (Find a first occurrence of a string in a string) info("int strScan(str _text1,str _text2,int _position,int _number)"); info("Searches a text string for the occurrence of another string."); info("_text1 - The text string to search."); info("_text2 - The string to find."); info("_position - The position at which the search should start."); info("_number - The number of characters that should be searched."); info(int2str(strScan("ABCDEFGHIJ","DE",1,10)));

Code to get customer Primary Address in Ax 2012

Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole

Get record from table on the basis of field id in Microsoft dynamics axapta x++

How to Get record from table on the basis of field id in dynamics axapta x++. just try following code in job to understand better way. emplTable emplTable; FieldId fieldId; ; fieldId = fieldNum(emplTable, Emplid); select emplTable; info(emplTable.(fieldId)); select emplTable where emplTable.(fieldId) == '1101'; info(emplTable.Name);