information :)
qbds = this.query().dataSourceTable(tablenum(LedgerTable));
qbds.addSortField(fieldId2Ext(fieldnum(LedgerTable, Dimension),
ledgerReport_TotalAndBalanceList.parmDimensionCriteria() +
1),SortOrder::Ascending);
for (i = 1; i <= qbds.sortFieldCount(); i++)
{
j = qbds.sortField(i);
j = fieldId2Ext(fieldnum(LedgerTable, Dimension),
ledgerReport_TotalAndBalanceList.parmDimensionCriteria() + 1);
if (qbds.sortField(i) == fieldId2Ext(fieldnum(LedgerTable,
Dimension), ledgerReport_TotalAndBalanceList.parmDimensionCriteria() +
1))
qbds.autoSum(i,true);
}
The "sortField" function on qbds says that it wants a fieldId as
argument ... actually it needs the sort field number (first field is 1,
second 2 and so on).
________________________________
From: Janno Liivak [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 30, 2004 1:37 PM
To: [EMAIL PROTECTED]
Subject: [development-axapta] autoSum on Dimension[x] field...
Hi
Axapta 3.0 SP2
in my report's fetch() method i have following code:
...
QueryBuildDataSource qbds;
;
qbds = this.query().dataSourceTable(tablenum(LedgerTable));
qbds.addSortField(fieldId2Ext(fieldnum(LedgerTable, Dimension),
ledgerReport_TotalAndBalanceList.parmDimensionCriteria() + 1));
qbds.autoSum(fieldId2Ext(fieldnum(LedgerTable, Dimension),
ledgerReport_TotalAndBalanceList.parmDimensionCriteria() + 1));
...
Why am i getting errors on the last line (no sort field no. 65545). Is
there any other way to do it?
the following is passed from class what calls the report and returns
selected dimension field (values 0 to 2).
ledgerReport_TotalAndBalanceList.parmDimensionCriteria()
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129a2jj2e/M=295196.4901138.6071305.3001176/
D=groups/S=1705006764:HM/EXP=1096627076/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com>
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=175368849>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
