return SysQuery::countTotal(this.queryRun());
or
return SysQuery::countTotal(this.queryRun());
depending on what you want to count.
(In your example, the result will be the same)
In this case, the count will take into account the ranges as specified in
the query.
Gert Neetesonne
Technical Product Manager
Edan Business Software
>From: "Steeve Gilbert" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: <[EMAIL PROTECTED]>
>Subject: RE : [development-axapta] Count in Reports
>Date: Tue, 6 Apr 2004 08:39:52 -0400
>
>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
>
>
>
>
>
_________________________________________________________________
Maak online je eigen website met Webbuilder http://webbuilder.msn.be
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.
