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.
