Показать сообщение отдельно
Старый 14.12.2007, 13:56   #1  
ist is offline
ist
Участник
 
60 / 10 (1) +
Регистрация: 29.07.2007
Query sort field autoSum
Hi,
How can I set AutoSum property on sorting field into Query with x++




I do this into Query Init method but without success.
X++:
    this.query().dataSourceTable(tablenum(LedgerTrans)).sortClear();
    this.query().dataSourceTable(tablenum(LedgerTrans)).addSortField(fieldnum(LedgerTrans, Voucher), SortOrder::Ascending);
    this.query().dataSourceTable(tablenum(LedgerTrans)).addSortField(fieldnum(LedgerTrans, TransDate), SortOrder::Ascending);
    this.query().dataSourceTable(tablenum(LedgerTrans)).addSortField(fieldnum(LedgerTrans, AccountNum), SortOrder::Ascending);
    this.query().dataSourceTable(tablenum(LedgerTrans)).autoSum(fieldNum(LedgerTrans, Voucher));
thank's in advance