PrivateProject_Tutorial_AutoSum.xpo

Exportfile for AOT version 1.0 or later
Formatversion: 1

***Element: RG

; Microsoft Dynamics AX Report: Tutorial_AutoSum udlæst
; --------------------------------------------------------------------------------
VERSION 1

REPORT #Tutorial_AutoSum
  PROPERTIES
    Name                #Tutorial_AutoSum
    Origin              #{2085ED89-8075-43D0-B3D6-A04EB3F9A212}
  ENDPROPERTIES

  METHODS
    SOURCE #fetch
      #public boolean fetch()
      #{
      #    QueryBuildDataSource qbdsCustTrans = query.dataSourceTable(tableNum(CustTrans));
      #    ;
      #    qbdsCustTrans.addSelectionField(fieldNum(CustTrans, AmountMST), selectionField::Sum);
      #    qbdsCustTrans.addGroupByField(fieldNum(CustTrans, AccountNum));
      #    qbdsCustTrans.addGroupByField(fieldNum(CustTrans, TransDate));
      #    qbdsCustTrans.addGroupByField(fieldNum(CustTrans, CurrencyCode));
      #    //info(qbdsCustTrans.toString());
      #    return super();
      #}
    ENDSOURCE
    SOURCE #classDeclaration
      #public class ReportRun extends ObjectRun
      #{
      #}
    ENDSOURCE
    SOURCE #init
      #public void init()
      #{
      #    QueryBuildDataSource    qbdsCustTrans;
      #    QueryOrderByField       QueryOrderByFielAccountNum;
      #    QueryOrderByField       QueryOrderByFieldTransDate;
      #    QueryOrderByField       QueryOrderByFielCurencyCode;
      #    ;
      #
      #    super();
      #
      #    qbdsCustTrans = query.dataSourceTable(tableNum(CustTrans));
      #    /*
      #    QueryOrderByFielAccountNum = qbdsCustTrans.addOrderByField(fieldNum(CustTrans, AccountNum));
      #    QueryOrderByFielAccountNum.autoHeader(true);
      #    QueryOrderByFieldTransDate = qbdsCustTrans.addOrderByField(fieldNum(CustTrans, TransDate));
      #    QueryOrderByFieldTransDate.autosum(true);
      #    QueryOrderByFielCurencyCode = qbdsCustTrans.addOrderByField(fieldNum(CustTrans, CurrencyCode));
      #    QueryOrderByFielCurencyCode.autoSum(true);
      #    */
      #    info(qbdsCustTrans.toString());
      #}
    ENDSOURCE
  ENDMETHODS
  QUERY #Query
    PROPERTIES
      Name                #Query
      Version             #23
      NextUniqueId        #1001
    ENDPROPERTIES

    METHODS
      SOURCE #classDeclaration
        #public class QueryRun extends ObjectRun
        #{
        #}
      ENDSOURCE
    ENDMETHODS
    BLOCKS
      BLOCK #CustTrans
        PROPERTIES
          Name                #CustTrans
          Table               #CustTrans
          UniqueId            #1000
        ENDPROPERTIES

        FIELDLIST
          PROPERTIES
            Dynamic             #No
          ENDPROPERTIES

          FIELD #AccountNum
          FIELD #TransDate
          FIELD #CurrencyCode
          FIELD #AmountMST
        ENDFIELDLIST
        SORTING
        ENDSORTING
        LINES
        ENDLINES
        BLOCKS
        ENDBLOCKS
        GROUPBY
        ENDGROUPBY
        HAVING
        ENDHAVING
        ORDERBY
          FIELD
            PROPERTIES
              DataSource          #CustTrans
              Field               #AccountNum
              AutoHeader          #Yes
            ENDPROPERTIES

          FIELD
            PROPERTIES
              DataSource          #CustTrans
              Field               #TransDate
              AutoSum             #Yes
            ENDPROPERTIES

          FIELD
            PROPERTIES
              DataSource          #CustTrans
              Field               #CurrencyCode
              AutoSum             #Yes
            ENDPROPERTIES

        ENDORDERBY
      ENDBLOCK
    ENDBLOCKS
    DEPENDENTS
    ENDDEPENDENTS
    COMPOSITEQUERIES
    ENDCOMPOSITEQUERIES
  ENDQUERY

  DESIGNS
    DESIGN
      PROPERTIES
        Name                #ReportDesign1
      ENDPROPERTIES

      AUTOBODIES
        PROPERTIES
        ENDPROPERTIES

        AUTOBODY #CustTrans
          PROPERTIES
            Name                #CustTrans_Body
          ENDPROPERTIES

          METHODS
          ENDMETHODS
          STRFIELD
            PROPERTIES
              Name                #CustTrans_AccountNum
              Table               #CustTrans
              DataField           #AccountNum
            ENDPROPERTIES

          ENDSTRFIELD
          DBLFIELD
            PROPERTIES
              Name                #CustTrans_AmountMST
              Table               #CustTrans
              DataField           #AmountMST
              SumAll              #Yes
            ENDPROPERTIES

          ENDDBLFIELD
          STRFIELD
            PROPERTIES
              Name                #CustTrans_CurrencyCode
              Table               #CustTrans
              DataField           #CurrencyCode
            ENDPROPERTIES

          ENDSTRFIELD
        ENDAUTOBODY
      ENDAUTOBODIES
    ENDDESIGN
  ENDDESIGNS
  PERMISSIONSET #Permissions
    PROPERTIES
    ENDPROPERTIES

    TABLES #Tables
    ENDTABLES

  SERVERMETHODS #Server Methods
  ENDSERVERMETHODS

ASSOCIATEDFORMS #Associated Forms
ENDASSOCIATEDFORMS

ENDPERMISSIONSET

ENDREPORT


***Element: FTM

; Microsoft Dynamics AX MENUITEM : Tutorial_AutoSum unloaded
; --------------------------------------------------------------------------------
  VERSION 1

  MENUITEM #Tutorial_AutoSum
    Type: 2
    PROPERTIES
      Name                #Tutorial_AutoSum
      ObjectType          #Report
      Object              #Tutorial_AutoSum
      Origin              #{5E6F62F0-D870-4588-92D1-A22A7CB827A9}
    ENDPROPERTIES

  ENDMENUITEM


***Element: PRN

; Microsoft Dynamics AX Project : Tutorial_AutoSum unloaded
; --------------------------------------------------------------------------------
  PROJECTVERSION 2

  PROJECT #Tutorial_AutoSum
  PRIVATE
  PROPERTIES
    Name                #Tutorial_AutoSum
    Origin              #{35DAEB84-A083-4FDB-A827-AA00F6208E00}
  ENDPROPERTIES

    PROJECTCLASS ProjectNode
    BEGINNODE
      FILETYPE 0
      UTILTYPE 18
      UTILOBJECTID 0
      NODETYPE 202
      NAME #Tutorial_AutoSum
    ENDNODE
    BEGINNODE
      FILETYPE 0
      UTILTYPE 2
      UTILOBJECTID 0
      NODETYPE 296
      NAME #Tutorial_AutoSum
    ENDNODE
  ENDPROJECT


***Element: END