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