How to get a datatable from ax to SSRs report

 

We can easily get a datatable from ax to SSRs report. All the business logic can be written in ax, and the SSRS is the data showing platform.

[DataMethod(), AxSessionPermission(SecurityAction.Assert)]public static DataTable GetData(string _PurchaseOrderId){    AxaptaWrapper ax = SessionManager.GetSession();    DataTable dt = (DataTable)ax.CallStaticClassMethod("ClassName", "StaticMethod", Parm1, Parm2...);    return dt;}

 

public static System.Data.DataTable GetData(){    System.Data.DataTable               m_DataTable;    System.Data.DataColumnCollection    m_DataColumnCon;    System.Data.DataRowCollection       m_DataRowCon;    System.Data.DataRow                 m_DataRow;    CustTable                           m_CustTable;    InteropPermission                   permission = new InteropPermission(InteropKind::ClrInterop);    ;    permission.assert();    m_DataTable     = new System.Data.DataTable();    m_DataColumnCon = m_DataTable.get_Columns();    m_DataRowCon    = m_DataTable.get_Rows();    m_DataColumnCon.Add("AccountNum");    m_DataColumnCon.Add("NameAlias");    while select m_CustTable    {        m_DataRow = m_DataTable.NewRow();        m_DataRow.set_Item("AccountNum", m_CustTable.AccountNum);        m_DataRow.set_Item("NameAlias", m_CustTable.NameAlias);        m_DataRowCon.Add(m_DataRow);    }    return m_DataTable;}

　　

　　

How to get a datatable from ax to SSRs report