adding new group header for date not working

ernest
Member Posts: 162
Hi all
I am trying to build a report based on the Serial No. Information table and I want to group my data according date, but it is not allowing me.
So it is grouping my data only according to Item No., Variant No. and Serial No.
I want to group my data by date, so in this date i have these serial number ect.
I tried by adding a new group, but it is not working.
Can you please suggest how can I solve this issue?
Thank you and best regards
I am trying to build a report based on the Serial No. Information table and I want to group my data according date, but it is not allowing me.
So it is grouping my data only according to Item No., Variant No. and Serial No.
I want to group my data by date, so in this date i have these serial number ect.
I tried by adding a new group, but it is not working.
Can you please suggest how can I solve this issue?
Thank you and best regards
0
Comments
-
Is it in classic or RTC?
What key do you have in DataItemTableView?
Is there any date field in Serial Number Information table or how do you want to do it?0 -
Classic.
SORTING(Item No.) ORDER(Ascending).
Yes there is a date field in this table, added by me.
Regards0 -
If you have to group it by date then you have to add the field in report key property..
You want to group it only on date or with some other field combination?0 -
So i want to do grouping by item (like it is now) and for each item add grouping by date.0
-
Just read the help documents how Grouping works on reports..
you ahve to have proper key in table..0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions