Re: [Axapta-Knowledge-Village] Re: Ax Report Query in 4.0

[Sumit Loya]

Hi Nitin,

Attached with this mail is a sample report depicting how to use a sum
control. You actually need not write any display method for sum control.

Regards,
Sumit

On Thu, Sep 11, 2008 at 2:02 PM, nitindesale <[EMAIL PROTECTED]>wrote:

>    --- In 
> Axapta-Knowledge-Village@yahoogroups.com<Axapta-Knowledge-Village%40yahoogroups.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,
> i am working on Generated design node as you said i have created sum
> field and got the out put , but it display grand total with single
> record and not all record with grand total.
> pls find the display method which is written.
>
> display real sumPostedValue()
> {
> real i;
> ;
> select sum (PostedValue) from inventSum;
>
> i=inventsum.PostedValue;
> return i;
> }
>
> 
>

Report_SamTest.xpo
Description: Binary data