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

      

      

  • 相关阅读:
    51串口通信
    juicer使用备忘
    51单片机音乐盒程序
    最精简24L01程序--接收
    sqlserver 数据库迁移
    sqlserver自增主键
    js keycode
    tabindex 去掉虚线
    div 绑定keyup
    sqlserver 当前时间减去30天
  • 原文地址:https://www.cnblogs.com/Jinnchu/p/3963747.html
Copyright © 2020-2023  润新知