--- In Axapta-Knowledge-Village@yahoogroups.com, "Sumit Loya"
<[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> First of please note that the automatic sum function works only on
the
> AutoDesignSpecs design node and not in the 'GeneratedDesign' node.
Secondly
> once you enable SumAll for a field you also need to enable Grand
Total
> property of the AutoDesignSpecs node.
>
> For Generated design node you can create a sum field and in its
> DataFieldName property specify the control that you need to sum.
Ensure that
> the control you will specify should have SumAll property enabled.
>
> Regards,
> Sumit
>
> On Thu, Sep 11, 2008 at 10:18 AM, NITIN DESALE
<[EMAIL PROTECTED]>wrote:
>
> > Hi All,
> >
> > A'm working on AX 4.0 in that there are two fields posted value &
posted
> > qty
> > i want to display the sum of these field in report , i hv set the
> > properites of that field SumAll is Yes till i'm not getting the
sum on
> > report.
> > In another report same condition have applied there it's working.
> > if u hv an idea abt it ,pls let me know the same.
> >
> > Regard's
> > Nitin Desale
> >
> >
> > Unlimited freedom, unlimited storage. Get it now, on
> > http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-
08.html/
> >
> >
>
Hi Sumit,
Thank'x for help ,i'm working in Generated design node in that
i created sum field as you said, i get the out put but it display
only grand total with single record and not all record with grand
total. pls refer the below code..
//
display real sumPostedValue()
{
real i;
;
select sum (PostedValue) from inventSum;
i=inventsum.PostedValue;
return i;
}
