RE : [development-axapta] How do I group Items and sum their SalesQty by Delivery date

[Steeve Gilbert]

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.