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
- 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