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
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 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
REPORT GROUPING - multiple items to print only once
CGaralde
Member Posts: 19
Hi,
I would like some tips on how to design a report in NAV 2013, in such a way as GROUPING a result and displaying it only once and getting the total.
Basically I have this scenario:
Parent Client XYZ
Child Client 1 ordered Item A = 5 pcs
Child Client 2 ordered Item A = 5 pcs
Child Client 3 ordered Item A = 7 pcs
Child Client 1 ordered Item B = 10 pcs
Child Client 3 ordered Item B = 3 pcs
Child Client 2 ordered Item C = 200 pcs
I want to create an invoice report showing items ordered by Parent Client XYZ, grouped by Item and regardless of Child Client. In other words:
Parent Client XYZ
Item A = 17 pcs
Item B = 13 pcs
Item C = 200 pcs
I am relatively new to NAV development, transitioned recently to NAV 2013 directly from 5.0. I used to experiment on this using GROUP FOOTERS/HEADERS and CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY) but what is the equivalent in NAV 2013?
Any help is appreciated, even pointing me to a similar report in Cronus is fine. Thanks.
I would like some tips on how to design a report in NAV 2013, in such a way as GROUPING a result and displaying it only once and getting the total.
Basically I have this scenario:
Parent Client XYZ
Child Client 1 ordered Item A = 5 pcs
Child Client 2 ordered Item A = 5 pcs
Child Client 3 ordered Item A = 7 pcs
Child Client 1 ordered Item B = 10 pcs
Child Client 3 ordered Item B = 3 pcs
Child Client 2 ordered Item C = 200 pcs
I want to create an invoice report showing items ordered by Parent Client XYZ, grouped by Item and regardless of Child Client. In other words:
Parent Client XYZ
Item A = 17 pcs
Item B = 13 pcs
Item C = 200 pcs
I am relatively new to NAV development, transitioned recently to NAV 2013 directly from 5.0. I used to experiment on this using GROUP FOOTERS/HEADERS and CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY) but what is the equivalent in NAV 2013?
Any help is appreciated, even pointing me to a similar report in Cronus is fine. Thanks.
0
Answers
You can group it inside the RDLC report to get your requirement. You can refer this link https://msdn.microsoft.com/en-us/library/ms170712.aspx to group inside the rdlc.
Regards,
Yukon
Thanks for taking the time, yukon.
I have already tried this in VISUAL STUDIO before posting here and I am getting the group but it always displays multiple times. I only want to display it once.
It's like in NAV 5.0, I group it by Item and it will only display when, for example:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY("CURRENT_ITEM_IS DIFFERENT_PREVIOUS_ITEM")).
Can you show us your report result and groping in rdlc? Me or someone can be suggestion on your case.
Here i did sample base on sales lines (Filter Doc. Type = Order and Type = Item)
Regards,
Yukon
I have attached a few things that might help you understand my situation better.
My ITEM equivalent is actually a combination of CODE,ARTICLE and COLOR and I have grouped group on this.
13 Clients have ordered ITEM "00ADNI008Z801" but I only want to show this once, and then the next ITEM "00ADNI0806W01" again ordered by multiple clients, again to be shown only once.
I am still experimenting on the displays so I have not configured the totals and such.
Thanks.
have a look in a standard report how grouping is done on multiple fields. In the screenshot an example from Report 206.
NAV Developer
Thanks everyone for taking some time to help. It is a silly mistake actually. I made a PARENT GROUP grouped by CODE, ARTICLE and COLOR but I did not group on the DETAILS. In retrospect, I don't even need to create a PARENT GROUP but just group on the DETAILS.