Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Wednesday, June 19, 2013

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();
    }
}

1 comment:

How find size of recordsortedlist in D365/AX 2012

Hi, This is the continuity of the previous article where we are now getting the size of recordsortedlist . if(recordsortedlist.len() >1) ...