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
- 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.
