Doubt in TotalsCausedby keyword in Report
chandrurec
Member Posts: 560
Hi all,
I am grouping by Customer No,Item cat Code and Prod group code.
So I have 2 footers one for displaying the quantity value based on Customerno,Item cat code and Prod group code grouping and another footer to display the Quantity sum based on the Customer No.So I am giving the following code to display the Quantity sum based on only Customer No grouping.
IF CurrReport.TOTALSCAUSEDBY IN [FIELDNO("Item Category Code"),FIELDNO("Product Group Code")]
THEN CurrReport.SHOWOUTPUT(FALSE);
But i am not getting the Quantity total getting displayed based on Customer No grouping.
If anyone knows the solutin for the above mentioned scenario, Kindly let me know.
Thanks in advance.
Regards,
chandru.
I am grouping by Customer No,Item cat Code and Prod group code.
So I have 2 footers one for displaying the quantity value based on Customerno,Item cat code and Prod group code grouping and another footer to display the Quantity sum based on the Customer No.So I am giving the following code to display the Quantity sum based on only Customer No grouping.
IF CurrReport.TOTALSCAUSEDBY IN [FIELDNO("Item Category Code"),FIELDNO("Product Group Code")]
THEN CurrReport.SHOWOUTPUT(FALSE);
But i am not getting the Quantity total getting displayed based on Customer No grouping.
If anyone knows the solutin for the above mentioned scenario, Kindly let me know.
Thanks in advance.
Regards,
chandru.
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions