Prev: Index Usage
Next: Connecting to NAV 5.0 Server as a Client
From: Andy on 5 Sep 2008 05:24
Hello,

I am creating a new report based on Value Entry table.
I want that all records are passed to calculate for examples cost amount but
in body section I want to display only records with Adjustment = no so I
write:


Value Entry, Body (3) - OnPreSection()

IF "Value Entry".Adjustment THEN
CurrReport.SHOWOUTPUT(FALSE);

I then have a section Group Footer in which the totals for amounts are good
but I don't want to have the quantity about Adjustment = yes summed otherwise
the total quantity are duplicated.

Is this possibile? How? With function TOTALSCAUSEDBY ?

Or do I have to write a lot of code and variables to manage sums?

Thank you
From: Andy on 5 Sep 2008 06:00
Maybe in this case I can expose the sum of the field Invoiced Quantity (that
has 0 value for adjustment = yes) in the group footer instead of Valued
Quantity ?

"Andy" wrote:

> Hello,
>
> I am creating a new report based on Value Entry table.
> I want that all records are passed to calculate for examples cost amount but
> in body section I want to display only records with Adjustment = no so I
> write:
>
>
> Value Entry, Body (3) - OnPreSection()
>
> IF "Value Entry".Adjustment THEN
> CurrReport.SHOWOUTPUT(FALSE);
>
> I then have a section Group Footer in which the totals for amounts are good
> but I don't want to have the quantity about Adjustment = yes summed otherwise
> the total quantity are duplicated.
>
> Is this possibile? How? With function TOTALSCAUSEDBY ?
>
> Or do I have to write a lot of code and variables to manage sums?
>
> Thank you
From: Daniel Rimmelzwaan on 5 Sep 2008 07:03
Why don't you set a filter on that field in the dataitem's
"DataItemTableView" property?

"Andy" <Andy(a)discussions.microsoft.com> wrote in message
news:ACD6BBDF-15A2-46C6-A114-6B64AB2CB153(a)microsoft.com...
> Hello,
>
> I am creating a new report based on Value Entry table.
> I want that all records are passed to calculate for examples cost amount
> but
> in body section I want to display only records with Adjustment = no so I
> write:
>
>
> Value Entry, Body (3) - OnPreSection()
>
> IF "Value Entry".Adjustment THEN
> CurrReport.SHOWOUTPUT(FALSE);
>
> I then have a section Group Footer in which the totals for amounts are
> good
> but I don't want to have the quantity about Adjustment = yes summed
> otherwise
> the total quantity are duplicated.
>
> Is this possibile? How? With function TOTALSCAUSEDBY ?
>
> Or do I have to write a lot of code and variables to manage sums?
>
> Thank you

From: Andy on 5 Sep 2008 07:08
Because I need the total sum of amounts but not qty duplicated.

"Daniel Rimmelzwaan" wrote:

> Why don't you set a filter on that field in the dataitem's
> "DataItemTableView" property?
>
> "Andy" <Andy(a)discussions.microsoft.com> wrote in message
> news:ACD6BBDF-15A2-46C6-A114-6B64AB2CB153(a)microsoft.com...
> > Hello,
> >
> > I am creating a new report based on Value Entry table.
> > I want that all records are passed to calculate for examples cost amount
> > but
> > in body section I want to display only records with Adjustment = no so I
> > write:
> >
> >
> > Value Entry, Body (3) - OnPreSection()
> >
> > IF "Value Entry".Adjustment THEN
> > CurrReport.SHOWOUTPUT(FALSE);
> >
> > I then have a section Group Footer in which the totals for amounts are
> > good
> > but I don't want to have the quantity about Adjustment = yes summed
> > otherwise
> > the total quantity are duplicated.
> >
> > Is this possibile? How? With function TOTALSCAUSEDBY ?
> >
> > Or do I have to write a lot of code and variables to manage sums?
> >
> > Thank you
>
 | 
Pages: 1
Prev: Index Usage
Next: Connecting to NAV 5.0 Server as a Client