--- In [EMAIL PROTECTED], "Steeve Gilbert"
<[EMAIL PROTECTED]> wrote:
> >Also if i use a view how would i group those fields plus I thought
> >aggregation in views are just based on numerical values.
>
> Nope, you can group on string too. Using the sum field will group
your fields. Here's what the view would look like...
>
> SalesTable
> |
> +-> SalesLine On SalesTable.SalesId = SalesLine.SalesId
> |
> +-> InventDim On InventDim.InventDimId = SalesLine.InventDimId
>
> Fields :
> InventDimId.InventLocationId
> SalesTable.DeliveryDate
> SalesTable.SalesId
> SalesLine.ItemId
> SalesLine.SalesQty (Sum Field)
>
> More explanation would be an XPO.
>
> Try it.
> Regards,
>
> Steeve...
>
> -----Message d'origine-----
> De�: k_otickashka [mailto:[EMAIL PROTECTED]
> Envoy�: 14 avril 2004 00:39
> ��: [EMAIL PROTECTED]
> Objet�: Re: RE : [development-axapta] How do I group Items and sum
their SalesQty by Delivery date
>
> Also if i use a view how would i group those fields plus I thought
> aggregation in views are just based on numerical values.
>
> --- In [EMAIL PROTECTED], "k_otickashka"
> <[EMAIL PROTECTED]> wrote:
> > What if I wanted to display the Sales item's location that is the
> > warehouse and group them that way.
> >
> > --- In [EMAIL PROTECTED], "Steeve Gilbert"
> > <[EMAIL PROTECTED]> wrote:
> > > I would create a view that contains SalesTable and SalesLine
with
> > only the fields needed and use that view in the dataSource of the
> > report. That way it would be easy to sort and group in the
> report.
> > I'm a bit of a view freak, I use view everywhere.
> > >
> > > Steeve...
> > >
> > > -----Message d'origine-----
> > > De�: k_otickashka [mailto:[EMAIL PROTECTED]
> > > Envoy�: 13 avril 2004 16:31
> > > ��: [EMAIL PROTECTED]
> > > Objet�: [development-axapta] How do I group Items and sum their
> > SalesQty by Delivery date
> > >
> > > I would like to print a report that represents a summary of a
> > sales
> > > order. In this report I would like each item that is repeated
in
> a
> > > salesLine for each salesorder to be grouped and sum the
quantity
> > > based on the delivery date of the sales order. EXAMPLE:
> > >
> > >
> > > SALESORDER 1
> > > DELIVERYDATE= 16/01/2002
> > > SALESLINE
> > > =========
> > > ITEM= OL-1000
> > > QUANTITY = 20
> > >
> > > SALESORDER 2
> > > DELIVERYDATE= 16/01/2002
> > > SALESLINE
> > > =========
> > > ITEM= OL-1000
> > > QUANTITY = 40
> > >
> > > The report should display:
> > >
> > > DATE 16/01/2002
> > > ITEM QUANTITY
> > > OL-1000 60
> > > ----------------------------------------------------------
> > > How can I achieve this?
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Yahoo! Groups Links
>
>
>
>
> Yahoo! Groups Links
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.
