- Microsoft Dynamics NAV 7 Programming Cookbook
- Table of Contents
- Microsoft Dynamics NAV 7 Programming Cookbook
- Credits
- About the Author
- About the Reviewers
- Acknowledgements
- www.PacktPub.com
- Preface
- 1. String, Dates, and Other Data Types
- Introduction
- Retrieving the system date and time
- Retrieving the work date
- Determining the day, month, and year from a given date
- Using the date formula to calculate dates
- Converting a value to a formatted string
- Creating an array
- Creating an option variable
- Converting a string to another data type
- Manipulating string contents
- 2. General Development
- Introduction
- Displaying the progress bar and data in process
- Repeating code using a loop
- Checking for conditions using an IF statement
- Using the CASE statement to test multiple conditions
- Rounding decimal values
- Creating functions
- Passing parameters by reference
- Referencing dynamic tables and fields
- Using recursion
- 3. Working with Tables, Records, and Queries
- Introduction
- Creating a table
- Adding a key to a table
- Retrieving data using the FIND and GET statements
- Advanced filtering
- Adding a FlowField
- Creating a SumIndexField
- Retrieving data from FlowField and SumIndexField
- Using a temporary table
- Retrieving data from other companies
- Using a query to extract data
- Creating a query to link three tables
- Working with queries in C/AL
- 4. Designing Pages
- Introduction
- Creating a page using a wizard
- Using multiple options to run the page
- Applying filters on the lookup page
- Updating the subform page from a parent page
- Creating a FactBox page
- Creating a Queue page
- Creating a Role Center page
- Creating a wizard page
- Displaying a .NET add-in on a page
- Adding a chart to the page
- 5. Report Design
- Introduction
- Creating an RDLC report
- Using multiple options to run a report
- Adding custom filters to the Request Page
- Setting filters when report is loaded
- Creating reports to process data
- Creating a link from report to page
- Creating a link from report to report
- Adding totals on decimal field
- Adding interactive sorting on reports
- Creating a matrix report
- 6. Diagnosing Code Problems
- 7. Roles and Security
- 8. Leveraging Microsoft Office
- 9. OS Interaction
- 10. Integration
- 11. Working with the SQL Server
- 12. NAV Server Administration
- Index
Rakesh Raul is from a small town in India, with a vision of doing something big in programming. He completed his first diploma in programming at the age of 16, and continued higher studies in computer software development.
He started his programming career with a small software development company in Mumbai. After 2 years of development in Visual Basic, he was introduced to Microsoft Dynamics NAV Version 3. For the first 2-3 years he worked as a Microsoft Dynamics NAV developer and at the same time he learned all the areas of the product and earned his first Microsoft Certification-Business Solutions Professional. He continues to stay updated with new releases of the product and is certified in multiple areas for versions 4.0, 5.0, 2009, and 2013. Apart from Microsoft Dynamics NAV, he also has good knowledge of Microsoft SQL Server and Business Intelligence.
His seven-year journey with Microsoft Dynamics NAV includes more than 30 implementations; one horizontal and two vertical solution designs and development.
Currently, he works in Tectura, India, as a Senior Technical Consultant. Tectura is a worldwide provider of business consulting services delivering innovative solutions.
I would like to thank my wife, Ashwini, for supporting and always standing by my side in good and bad days.
I would like to take this opportunity to thank all the mentors I was blessed with, who unconditionally shared their knowledge and inspired me.
Mibuso and all Microsoft Dynamics NAV related blogs are a great boon for all NAV consultants. I would like to thank all the contributors of these great sites.
Love you Aabha, my cute little princess!
-
No Comment