Microsoft Dynamics NAV 7 Programming Cookbook

Microsoft Dynamics NAV 7 Programming Cookbook - Second Edition

Overview of this book

Microsoft Dynamics NAV 7 is a business management solution that helps simplify and streamline highly specialized business processes. Learning NAV programing in NAV 7 gives you the full inside view of an ERP system. Microsoft Dynamics NAV 7 Programming Cookbook covers topics that span a wide range of areas such as integrating the NAV system with other software applications including Microsoft Office, and creating reports to present information from multiple areas of the system,. We will not only learn the essentials of NAV programming, you will also be exposed to the technologies that surround NAV including.NET programming, SQL Server and NAV system administration. Microsoft Dynamics NAV 7 Programming Cookbook is written in a direct, to-the-point style to help you get what you need and continue working in NAV. The first half of the cookbook will help programmers using NAV for the first time, by walking them through the building blocks of writing code and creating objects such as tables, pages, and reports. The second half focuses on using the technologies surrounding NAV to build better solutions. You will learn how to write .NET code that works with the NAV system and how to integrate the system with other software applications such as Microsoft Office or even custom programs. You will learn everything you need to know for developing all types of NAV CSIDE objects, as well as how to integrate and maintain a NAV system.

Microsoft Dynamics NAV 7 Programming Cookbook

Credits

About the Author

About the Reviewers

Acknowledgements

www.PacktPub.com

Preface

Free Chapter

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

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

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

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

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

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

Roles and Security

Introduction

Assigning a role to a user

Creating a new role

Using 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

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

OS Interaction

Introduction

Using HYPERLINK to open external files

Working with environmental variables

Using SHELL to run external applications

Browsing for a file

Browsing for a folder

Checking file and folder access permissions

Querying the registry

Zipping folders and files within NAV

Integration

Introduction

Sharing information through XMLports

Writing to and reading from a file using the C/AL code

Creating web services

Consuming web services

Sending data through FTP

Printing a report in a PDF, Excel, and Word format

Writing your own automation using C#

Using ADO to access outside data

Working with the SQL Server

Introduction

Creating a basic SQL query

Understanding SIFT

Using the SQL profiler

Displaying data from a SQL view in NAV

Identifying Blocked and Blocking sessions from SQL

Setting up a backup plan

Maintaining the transaction logfiles

NAV Server Administration

Introduction

Creating a NAV Server Instance

Configuring NAS to run Job Queue

Creating a user on NAV

Changing the NAV license

Creating a new database

Testing the NAV database

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Creating an array

Creating multiple variables to store related information can be time consuming. It leads to more code and more work. Using an array to store related and similar types of information can speed up development and lead to much more manageable code. This recipe will show you how to create and access array elements.

How to do it...

Let's create a new codeunit from Object Designer.
Add the following global variables by navigating to View | C/AL Globals (Alt + V + B):

Name

Type

i

Integer

IntArray

Integer
Now, with the cursor on the IntArray variable, navigate to View | Properties (Shift + F4).
In the Property window, set the following property:

Property

Value

Dimensions

10

Name	Type
`i`	Integer
`IntArray`	Integer

Property	Value
Dimensions	`10`

Write the following code into the OnRun trigger of the codeunit:

FOR i := 1 TO ARRAYLEN(IntArray) DO BEGIN
  IntArray[i] := i;
  MESSAGE('IntArray[%1] = %2', i, IntArray[i]);
END;

To complete the task, save and close the codeunit.
On executing the codeunit, you should see a window similar to the following screenshot:

How it works...

An array is a single variable that holds multiple values. The values are accessed using an integer index. The index is passed within square brackets ([ ]).

Note

NAV provides several functions to work with arrays. For instance, ARRAYLEN returns the number of dimensions of the array and COPYARRAY will copy all of the values from one array into a new array variable. You can find a complete list of the array functions in the Developer and IT Pro Help option in the Help menu of Microsoft NAV Development Environment.

There's more...

Open the 365, Format Address codeunit. Notice that the first function, FormatAddr, has a parameter that is an array. This is the basic function that all of the address formats use. It is rather long, so we will discuss only a few parts of it here.

This first section determines how the address should be presented based on the country of the user. Variables are initialized depending on which line of the address should carry certain information. These variables will be the indexes of our array.

CASE Country."Contact Address Format" OF
  Country."Contact Address Format"::First:
    BEGIN
      NameLineNo := 2;
      Name2LineNo := 3;
      ContLineNo := 1;
      AddrLineNo := 4;
      Addr2LineNo := 5;
      PostCodeCityLineNo := 6;
      CountyLineNo := 7;
      CountryLineNo := 8;
    END;

Then we will fill in the array values in the following manner:

AddrArray[NameLineNo] := Name;
AddrArray[Name2LineNo] := Name2;
AddrArray[AddrLineNo] := Addr;
AddrArray[Addr2LineNo] := Addr2;

Scroll down and take a look at all of the other functions. You'll see that they all take in an array as the first parameter. It is always a text array of length 90 with eight dimensions. These are the functions you will call when you want to format an address. To use this codeunit correctly, we will need to create an empty array with the specifications listed before and pass it to the correct function. Our array will be populated with the appropriately formatted address data.

Microsoft Dynamics NAV 7 Programming Cookbook - Second Edition

Microsoft Dynamics NAV 7 Programming Cookbook - Second Edition

Overview of this book

Related Content you might be interested in

Current Title:

Microsoft Dynamics NAV 7 Programming Cookbook - Second Edition

Creating an array

How to do it...

How it works...

Note

There's more...

See also