preloader-matrix

Alfasith

SSRS Reports using DP Class in Dynamic AX

/***********************Class declaration****************************/
/// <summary>
///    Declares variables and tables for the <c>AssetBookCompare</c> report.
/// </summary>
[
SRSReportQueryAttribute(querystr(CustReport))//,
//  SRSReportParameterAttribute(classstr(AssetBookCompareContract))
]
public class CustReportClassDP extends SRSReportDataProviderBase
{
TmpCustTbl TmpCustTbl;
}

/********************** GetTempData*****************************/
[
SrsReportDataSetAttribute(tablestr(TmpCustTbl))
]
public TmpCustTbl getTempData()
{
select TmpCustTbl;
return TmpCustTbl;
}

/*******************insertTempData *********************************/
private void insertTempData()
{

CustTable CustTable;
CustTrans CustTrans;

TmpCustTbl.CurrencyCode = CustTrans.CurrencyCode;
TmpCustTbl.CollectionLetterCode = CustTrans.CollectionLetterCode;
TmpCustTbl.CashPayment = CustTrans.CashPayment;
TmpCustTbl.CancelledPayment = CustTrans.CancelledPayment;
TmpCustTbl.BirthDate_IT = CustTable.BirthDate_IT;
TmpCustTbl.BirthPlace_IT = CustTable.BirthPlace_IT;
TmpCustTbl.Currency = CustTable.Currency;
TmpCustTbl.Blocked = CustTable.Blocked;
TmpCustTbl.BankAccount = CustTable.BankAccount;
TmpCustTbl.AccountNum = CustTable.AccountNum;

TmpCustTbl.insert();

}

/**********************************processReport **********************************/
[SysEntryPointAttribute]
public void processReport()
{
CustTable CustTable;
CustTrans CustTrans;
Query query = new Query(this.parmQuery());
QueryRun queryRun;

queryRun = new QueryRun(query);

while (queryRun.next())
{

CustTable = queryRun.get(tablenum(CustTable));
CustTrans = queryRun.get(tablenum(CustTrans));

this.insertTempData();
}
}

One Response

Leave a Reply

Your email address will not be published. Required fields are marked *