Dynamic Grouping in Report NAV 2009

PratyushaMenon
Member Posts: 18
I have a requirement of creating a report that groups the output , on the basis of the grouping option selected by the user. The report primarily has to group on bass of the following parameters: Customer,Salesperson Code,City,State (coming from Customer table) and Global Dimension 1 (i.e. Location) and Global Dimension 2 (i.e. Branch) (coming from the Location table). I had decided to initially test the grouping only on Customer fields. So this is how I did it:
***** For Customer Grouping****
IF GroupBy = GroupBy::Customer THEN
BEGIN
Customer.SETCURRENTKEY("No.");
CurrReport.SHOWOUTPUT := CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO(Customer."No.")
END
ELSE
CurrReport.SHOWOUTPUT := FALSE;
*******For Salesperson Code*********
IF GroupBy = GroupBy::Salesperson THEN
BEGIN
Customer.SETCURRENTKEY("Salesperson Code",City,"State Code");
CurrReport.SHOWOUTPUT := CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO(Customer."Salesperson Code")
END
ELSE
CurrReport.SHOWOUTPUT := FALSE;
And so on for other parameters. Where GroupBy is an Option variable.
However, the Report output comes out blank.
Any suggestion would be highly appreciated.
***** For Customer Grouping****
IF GroupBy = GroupBy::Customer THEN
BEGIN
Customer.SETCURRENTKEY("No.");
CurrReport.SHOWOUTPUT := CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO(Customer."No.")
END
ELSE
CurrReport.SHOWOUTPUT := FALSE;
*******For Salesperson Code*********
IF GroupBy = GroupBy::Salesperson THEN
BEGIN
Customer.SETCURRENTKEY("Salesperson Code",City,"State Code");
CurrReport.SHOWOUTPUT := CurrReport.TOTALSCAUSEDBY = Customer.FIELDNO(Customer."Salesperson Code")
END
ELSE
CurrReport.SHOWOUTPUT := FALSE;
And so on for other parameters. Where GroupBy is an Option variable.
However, the Report output comes out blank.
Any suggestion would be highly appreciated.
0
Comments
-
You need to do the following...
1) Set the GroupTotalFields property of the Customer dataitem to "No.","Salesperson Code"
2) Use SETCURRENTKEY to set the appropriate key in the OnPreDataitem trigger (not on OnPreSection triggers)
3) Use TOTALSCAUSEDBY in the OnPreSection triggers to show/hide sections (as you are doing)0 -
Thanks a million for the help...! And sorry for the late acknowledgement
=D>
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