group total fields... report

demi222
Member Posts: 131
I have made a report that only looks at one table.
I made a key in that table.... Cust No., Cust Name, Cust Status.
In the report I put Cust No., Cust Name, Cust Status in the DataItemTableView
I also put Cust No., Cust Name, Cust LastName Cust Status in the GroupTotalFields
In the TotalFields I put Amount and Hours
I have made a groupheader with Cust No., Cust Name,Cust LastName and Cust Status.
I have made a groupFooter with Amount and Hours...and on the presection of the groupfooter I have written:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = FIELDNO("Cust Status"));
What I want is for Amount and Hours to be totaled for each customer for each Status.
For example, if there exists Status 1, Status 2, and Status 3
I want the following:
100025......Jon.....Doe
................................Status 1....5.33....3 hours
................................Status 2....71.0....8 hours
100026.......Jane.......Smith
................................Status 1....7.77....2 hours
................................Status 2....8.89....3 hours
................................Status 3....10.5....5 hours
Have I done things wrong?
what is happening now is that the Cust No., Cust Name,Cust LastName and Cust Status show... but only the first status that is in the table... also, Hours and Amount do not show.
If I take out the code in the onpresection of my groupfooter, it shows Hours and Amount, but the total, without taking into account the Cust Status.
can anyone help?
I made a key in that table.... Cust No., Cust Name, Cust Status.
In the report I put Cust No., Cust Name, Cust Status in the DataItemTableView
I also put Cust No., Cust Name, Cust LastName Cust Status in the GroupTotalFields
In the TotalFields I put Amount and Hours
I have made a groupheader with Cust No., Cust Name,Cust LastName and Cust Status.
I have made a groupFooter with Amount and Hours...and on the presection of the groupfooter I have written:
CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = FIELDNO("Cust Status"));
What I want is for Amount and Hours to be totaled for each customer for each Status.
For example, if there exists Status 1, Status 2, and Status 3
I want the following:
100025......Jon.....Doe
................................Status 1....5.33....3 hours
................................Status 2....71.0....8 hours
100026.......Jane.......Smith
................................Status 1....7.77....2 hours
................................Status 2....8.89....3 hours
................................Status 3....10.5....5 hours
Have I done things wrong?
what is happening now is that the Cust No., Cust Name,Cust LastName and Cust Status show... but only the first status that is in the table... also, Hours and Amount do not show.
If I take out the code in the onpresection of my groupfooter, it shows Hours and Amount, but the total, without taking into account the Cust Status.
can anyone help?
0
Comments
-
Too much errors in one idea
At first - you need a key only for "Cust No.", "Cust Status"
The same is for "GroupTotalFields" property
Amount and Hours must be in "TotalFields" property.
Wish you luck0
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