GroupBy in DataItem

nikeman77

Hi everyone,

If I have GroupBy 2 fields in a DataItem (Eg: DataItem-Cust. Ledger Entry , GroupBy- Salesperson Code AND Customer Code), in my section designer how can I inform system to show grouping of Salesperson on First Cust. Ledger Entry GroupFooter and grouping of Customer on Second Cust. Ledger Entry GroupFooter

JDI

mohana_cse06

Use

CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO("Sales Person Code");



CurrReport.SHOWOUTPUT :=

CurrReport.TOTALSCAUSEDBY = CustomerLedgerEntry.FIELDNO("Customer No.");

nikeman77

Hi Mohana,

1.I insert both the code (Salesperson Code, Customer No.) as instructed nothing appear at all.

2.My structure as follows:
2.1.Salesperson/Purchaser
2.2.Cust. Ledger Entry (DataItemLink : Salesperson Code=FIELD(Code),
TotalFields : Sales (LCY),
GroupTotalFields : Salesperson Code,Customer No.)

3.Objective of report:
3.1 User Input Posting Date Range> System retrieve all Salesperson Sales by Posting Date, Group by Salesperson No.,
3.2 When repeating customer occur within the posting date for SAME Salesperson, only display customer name, no. once,
BUT Sales (LCY) must be accumulate.
3.3 For similar salesperson posting date of (1 year ago : '-1y'), if there is same customer, insert in same row
DIFFERENT column for comparison.

4.ISSUE:
4.1 Unable to group repeating customer, system will print all customer (regardless if its the same customer by same
salesperson)
4.2 Previous amount unable to retrieve if it does not fall under the same date as current year (current year posting date
range is input by user).

JDI