Hi there..
I've done Group total fields with only DATE and amount, but now I want to add Salesperson Code there, how can I make it?
01/01/01
PS........ 1500
JR........ 3000
4500
Something like that...
Im using only 1 dataitem (Cust.Ledger.Entry)
please help
0
Answers
www.NextEqualZero.com
A technical eye on Dynamics NAV
I know that, but what I gonna do next?
Enter the field(s) you wish to group by in the GroupTotalFields property.
Enter the field(s) you wish to total, e.g. Remaining Amount, in the TotalFields property
Add group header and group footer sections with your total fields as appropriate.
Hope this helps
www.NextEqualZero.com
A technical eye on Dynamics NAV
01/01/01 100
01/01/01 100
02/02/02 50
01/01/01 200
02/02/02 50
Now imagine
01/01/01 PS 100
01/01/01 PS 200
01/01/01 JR 50
in Result I want
01/01/01 PS 300
JR 50
group both: dates and Salespersons and ofcourse total sums.
Do you understand me?
1) Create a key in table - Customer ledger Entry [Posting Date,Salesperson Code]
2) take the following Report object ... O:) .. and do the necessary formatting
Technical Consultant, MS Dynamics NAV
Thanks a lot.. I got it
TOTALSCAUSEDBY and SHOWOUTPUT solved the problem ;-)