report 120 and group by salesperson

teckpoh
teckpoh Member Posts: 271
edited 2006-12-19 in NAV/Navision Classic Client
hi all,

i need to customize a report 120 "Aged Accounts Receivables".
what i try to do is to group the report by the salesperson.
eg: salesperson JS hv 5 customer then

Salesperson: JS

customer no
1) xxxxxxxxxx xxxxx
2) xxxxxxxxxxxxxxx
.
.
5)XXXXXXXXXXXXXX

but i've no idea on it.

although i already set the key for the customer table...but it didn't work also..the rpt only group by salesperson when the user filter the salesperson code b4 preview the report....

IF user do not filter the salesperson...the report display all record that belong to all salesperson within the aging period.

Comments

  • Waldo
    Waldo Member Posts: 3,412
    Did you try to create an extra data item (sales person) and group that way?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • teckpoh
    teckpoh Member Posts: 271
    coz the customer & "cust. ledger entry" table itself hv the "salesperson code" field tat y i do not add "salesperson/purchaser" table for dataitem
  • Oneway
    Oneway Member Posts: 53
    check any reset in the code. u can use setcurrentkey after the reset
  • teckpoh
    teckpoh Member Posts: 271
    10s all guys....my problem solved...wat i do is add a group header for the data item..to group a particular salesperson code..then solved.

Categories