Grouping And TotalsCausedBy

Kc_Nirvana
Kc_Nirvana Member Posts: 146
edited 2011-01-28 in NAV/Navision Classic Client
Hello....
I want to group my report by various fields
My report is about the item ledger entry and i want that the report groups whenever a "item No.", "variant code" or "location code" of a item changes.

And it is possible to have a total field in group header instead of group footer?
Thanks in advance....
Junior Consultant & Developer in Dynamics NAV

"I'm worse at what I do best
And for this gift I feel blessed
Our little group has always been
And always will until the end"

Nirvana - Nevermind - Smells Like Teen Spirit

Answers

  • rhpnt
    rhpnt Member Posts: 688
    Lookup "Totalscausedby" in NAV online help.
  • Belias
    Belias Member Posts: 2,998
    Kc_Nirvana wrote:
    And it is possible to have a total field in group header instead of group footer?
    Not out of the box. You have to use RDLC layout (if possible). Otherwise you have calculate the total (or subtotal) by code before the group starts.

    P.S.: totalscausedby is not the only way to go, you can (for example) create a new dataitem on "item" table, and then indent and link your item ledger entry dataitem to it...but i don't want to mess up your ideas: it's better for you to read some manuals :wink:
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • Kc_Nirvana
    Kc_Nirvana Member Posts: 146
    I am doing a report that objective is to count the itens that arrived in a date and then show the order lines that are pending for that item.

    What i want is this:
    Grouping Item Ledger Entry by Item No., Variant Code, Location Code

    Standart Report:

    Item Nr 1
    Variant GREEN
    Location 10

    Order XPTO Quantity 10

    Variant BLUE
    Location 10

    Order XPTO Quantity 10

    What i want to show:

    Item Nr 1 Variant GREEN Location 10

    Order XPTO Quantity 10

    Item Nr 1 Variant BLUE Location 10

    Order XPTO Quantity 10


    But if i remove the Showoutput(TotalsCausedby) the report shows me 3 equal lines

    How can i solve this?
    Junior Consultant & Developer in Dynamics NAV

    "I'm worse at what I do best
    And for this gift I feel blessed
    Our little group has always been
    And always will until the end"

    Nirvana - Nevermind - Smells Like Teen Spirit
  • PeterVersteege
    PeterVersteege Member Posts: 13
    You write : Grouping by Item No., Variant Code, Location Code.

    I don't know which key you are using, but if the key starts with Item No. , Variant Code, Location Code , you should try to set the GroupField only to 'Location Code' (and delete the Groupfields Item No. & Variant Code). You will not need the TotalsCausedBy anymore , and it will print 1 time for every combination of Item No, Variant Code and Location Code.
    K3 Business Solutions
  • Kc_Nirvana
    Kc_Nirvana Member Posts: 146
    PeterVersteege wrote:
    You write : Grouping by Item No., Variant Code, Location Code.

    I don't know which key you are using, but if the key starts with Item No. , Variant Code, Location Code , you should try to set the GroupField only to 'Location Code' (and delete the Groupfields Item No. & Variant Code). You will not need the TotalsCausedBy anymore , and it will print 1 time for every combination of Item No, Variant Code and Location Code.

    Spectacular answer..........
    It worked.............
    Thank you.............
    Junior Consultant & Developer in Dynamics NAV

    "I'm worse at what I do best
    And for this gift I feel blessed
    Our little group has always been
    And always will until the end"

    Nirvana - Nevermind - Smells Like Teen Spirit

Categories