Grouping Fields

jmlozares
jmlozares Member Posts: 110
edited 2005-01-07 in NAV/Navision Classic Client
I'm doing a report that has something to do with item table. The report should classify the item according to its Division, Dept. and Group. What I've done to achieve this is to first sort the item respectively. Next, I've set the dataitem's GrouptotalFields property to "Item Division, Item Department, Item Group Code" in order to group it.

In the section designer I've added a GrourHeader and place a textbox for the current group's Division, Dept. and Group.

I have also added a Body for the item detail.

Everything goes okey, but there is something wrong with the output. There are GroupHeader section that appeared twice in the output.


Sample Output:
___________________________________________________________
Item Code Description

Division : 001
Dept : 111
Group : 234
Division : 001
Dept : 111
Group : 234

item001 Sample Item1
item002 Sample Item2

___________________________________________________________
Janderol Lozares Jr.
Manila, Phils.

Comments

  • kine
    kine Member Posts: 12,562
    Have you used the right key for sorting? It must start with the fields you group... must start "Item Division, Item Department, Item Group Code..."
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • eromein
    eromein Member Posts: 589
    Be sure you have the richt (needed) key in the table you are looping. Then try to make the report using the WIZARD!

    You will need to code some statements in the group sections. If you use the wizard this will be done for ya.

    Check the link below for help how to use the wizard:

    Click this link to download the Navision Bible!
    "Real programmers don't comment their code.
    If it was hard to write, it should be hard to understand."

Categories