Module 1: DATA AND PROCESS MODEL
Module 2: MASTER TABLES AND PAGES
Module 3: DOCUMENTS
Module 4: POSTING
Module 5: FEATURE INTEGRATION
Module 6: REPORTING
Module 7: STATISTICS
Module 8: DIMENSIONS
Module 9: ROLE TAILORING
Module 10: INTERFACES
Module 11: WEB SERVICES
Module 12: TESTING AND DEBUGGING
Module 13: SQL SERVER OPTIMIZATION
- Lesson 1: SQL Server for Microsoft Dynamics NAV
- Lesson 2: Representation of NAV Tables and Indexes in SQL Server
- Lesson 3: Collation Options
- Lesson 4: SQL Server Query Optimizer
- Lesson 5: SQL Server Query Optimizer
- Lesson 6: Data Access Redesign
- Lesson 7: C/AL Database Functions and Performance on SQL Server
- Lesson 8: Bulk Inserts
- Lesson 9: Locking, Blocking, and Deadlocks
- Lesson 10: SIFT Data Storage in SQL Server
- Lesson 11: SQL Server Profiler
Lesson 2: Seminar Statistics
Seminarstatistics lets the user quickly and easily retrieve an overview of the price statistics for a specific seminar.
You can use FlowFields and FlowFilters on the seminar solution to provide statistics as described in the functional requirements in Module 1, Business Case Diagnosis and Analysis. The client requires statistics for different time periods, such as for a month, for last year, for this year, and up to the current date.
This requirement indicates that the client wants to open a Statistics page from a Seminar page. This page calculates the statistics for the total price and shows it for the four time periods that are listed. Seminar managers should have access to the seminar statistics from a Seminar Detail page. This page calculates the total price statistics for the seminar for the time periods that are indicated in the function requirements.
The Seminar Statistics page must be available from the Related Information menu on the Seminar Card and Seminar List pages. The SeminarStatistics page automatically calculates the statistics for the selected seminar by using the information from the Seminar Ledger Entry page.
Seminar Card (Page 123456700): The Seminar menu selection on the Related Information button on this page is changed to include a new command for seminar statistics.
Seminar List (Page 123456701): The Seminar menu selection on the Related Information button on this page is changed to include a new command for seminar statistics. The solution requires the addition of FlowFields and FlowFilters to the Seminar table (123456700). Also, a key of Seminar No., Posting Date, Charge Type, Chargeable is added to the Seminar Ledger Entry table 123456732.
Use values from the Seminar Ledger Entry page to calculate the Total Price, Total Price (Chargeable) and Total Price (Not Chargeable) in the Seminar table, for four time periods. Use an array of four dimensions to store the totals for each of these three prices. Use the standard DateFilter-Calc codeunit to calculate date filters for the time periods. With the date filters, you can filter the Seminar table and use it to calculate the price fields that are shown on the page for each time period.