Tuesday, September 27, 2016

Call SSRS Repart class and Table data through Job in Ax 2012

To SSRS Repart class and Table data through Job in Ax 2012 you can try below code.


   TestTmp tempTable;  
   TestDP dataProvider = new TestDP();  
   TestContract contract = new TestContract();  
   contract.parmCustAccount("Test00001");  
   contract.parmNofSample(8);  
   dataProvider.parmDataContract(contract);  
   dataProvider.processReport();  
   tempTable = dataProvider.getTestTmp();  
   while select tempTable  
   {  
     info(strFmt("%1,%2,%3,%4",tempTable.CurrencyCode,tempTable.SalesId,tempTable.Monthname,tempTable.CurrentMonthSum));  
   }  

Here TestDP is data provider class for SSRS Report and TestContract is contract class . To pass parameter value we used parmCustAccount and parmNofSample method from contract class. tempTable is temparary table used in DP class.