Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Grouping Fields
jmlozares
Member Posts: 110
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
___________________________________________________________
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.
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."