Need help with report & group totals

Smashed_PumpkinSmashed_Pumpkin Member Posts: 47
edited 2006-07-06 in Navision Attain
Hi all,

I need to create a report that takes the Item No.2 field and gives a group total on a flowfield called "Total Sales".

Part 1
No.: A-CTB2010/5LL
No.2: A-CTB2010
Total Sales: 2
Part 2
No. A-CTB2010/6AA
No.2 A-CTB2010
Total Sales: 6

I need the report to simply show:

Part No.______Total Sales

How do I do this? I'm still a novice when it comes to reports, though I know how to create them in terms of adding fields, etc. Thanks in advance for any help.


  • Miklos_HollenderMiklos_Hollender Member Posts: 1,598
    I think the basics are :

    - creating a key for No. 2 in table/design/view menu
    - set dataitemtableview on dataitem to it, grouptotalfields on report dataitem to it, and totalfields to totalsales
    - put totalsales in groupfooter
  • Smashed_PumpkinSmashed_Pumpkin Member Posts: 47
    Thanks Miklos, will give that a go.
  • Smashed_PumpkinSmashed_Pumpkin Member Posts: 47
    It worked great, thanks :)
Sign In or Register to comment.