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.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
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!
If it was hard to write, it should be hard to understand."