I copied from Technet 4461.2
SysQuery::countTotal(this.queryRun())
Returns number of records in query
Good luck
Tony
-----Original Message-----
From: Steeve Gilbert [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 6 April 2004 10:40 PM
To: [EMAIL PROTECTED]
Subject: RE : [development-axapta] Count in Reports
I don't think there's build-in feature to do that. It's still simple to do anyway. You can create RealEdit field that would call this function :
display real emplQty() {
EmplTable emplTab;
select count(RecId) from emplTab;
return emplTab.RecId;
}
That would give the number of record in EmplTable whatever the range set by the user on the report. If your report has some ranges and you want the number of employees printed on the report then declare some Int variable in ClassDeclaration and increment it each time you print an EmplTable line (in the executeSection method).
Are you ok with this?
Regards,
Steeve...
-----Message d'origine-----
De�: ax_ruetz [mailto:[EMAIL PROTECTED]
Envoy�: 6 avril 2004 04:33
��: [EMAIL PROTECTED]
Objet�: [development-axapta] Count in Reports
Hi Everybody,
i am new to Axapta and have a simple question about reports. I want to make a report of the EmplTable. It should print a list of all employes. This is not a problem, it does what i want and is very easy.
but my problem is that i want to count all employes and print the number of them at the end of the report. how can i do that?
Michael
Yahoo! Groups Links
Yahoo! Groups Links
| 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.
