Microsoft Dynamics NAV 7 Programming Cookbook / Rakesh Raul.

Print version record.

Written in the style of a cookbook. Microsoft Dynamics NAV 7 Programming Cookbook is full of recipes to help you get the job done. If you are a junior / entry-level NAV developer then the first half of the book is designed primarily for you. You may or may not have any experience programming. It focuses on the basics of NAV programming. If you are a mid-level NAV developer, you will find these chapters explain how to think outside of the NAV box when building solutions. There are also recipes that senior developers will find useful.

Cover; Copyright; Credits; About the Author; About the Reviewers; Acknowledgements; www.PacktPub.com; Table of Contents; Preface; Chapter 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; Chapter 2:General Development; Introduction.

Displaying the progress bar and data in processRepeating 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; Chapter 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 tableRetrieving data from other companies; Using a query to extract data; Creating a query to link three tables; Working with queries in C/AL; Chapter 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; Chapter 5:Report Design; Introduction; Creating an RDLC report.

Using multiple options to run a reportAdding 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; Chapter 6:Diagnosing Code Problems; Introduction; Using the debugger; Setting breakpoints; Handling runtime errors; Using About This Page and About This Report; Finding errors while using NAS; Chapter 7:Roles and Security; Introduction; Assigning a role to a user.

Creating a new roleUsing the FILTERGROUP function; Using security filters; Applying security filter modes; Field-level security; Assigning permission to use the About This Page function; Killing a user session; Chapter 8:Leveraging Microsoft Office; Introduction; Sending data to Microsoft Word; Managing stylesheets; Sending an e-mail from NAV through SMTP; Exporting data using the Excel Buffer; Creating data connection from Excel to NAV; Showing data in Excel using PowerPivot; Creating an InfoPath form for the NAV data; Creating charts with Visio; Chapter 9:OS Interaction; Introduction.

Added to collection customer.56279.3