Using variables and C/AL code in a report in NAV 2009

This previous blog “NAV 2009 – The structure of reports in VS report designer” describes how to get data from your data items into the layout of a report in Visual Studio (VS) report designer. This time we look at how to control the iterations of a report with code, and showing variables rather than fields…


NAV 2009 – The structure of reports in VS report designer

One thing is to make a report look pretty. But before you can do that, you have to make it work first. This post is about how to get the data structure right when designing reports in VS report designer for the new client in NAV 2009. If you are completely new to the new…


NAV 2009 – Report Designer – Introduction to the new environment

  Microsoft Dynamics NAV has always had its own report designer. In NAV 2009 it still does, but in addition to this you can also use the Visual Studio (VS) report designer. NAV 2009 – both the classic and the new client – will still run reports designed in NAV’s report designer. So in way…


Dynamics NAV 5.0 SP1 and export to Excel

A number of issues previously reported when running with Dynamics NAV 5.0 and using send-to Excel functionality, are now corrected.  These issues include (among others): decimals exported as text, Item/Customer numbers exported as decimals, dates exported as decimals. To implement correction, update with 5.0 SP1, update 1 (KB 956161, build 27191), use default style sheets included in SP1, and make the following change to…

3

Basic SQL – Restoring a SQL Server backup

This post is part of “Overview of NAV-specific SQL features for application consultants“. You can back up your Microsoft Dynamics NAV database either from a NAV client or from SQL Server Management Studio. To restore a backup made from SQL Server, follow these steps: 1)     Open SQL Server Management Studio 2)    You don’t need to…


Basic SQL – Creating users in NAV on SQL

This post is part of “Overview of NAV-specific SQL features for application consultants“. Before you can set up a user in Microsoft Dynamics NAV on SQL Server, you must create the user on SQL Server first. If you try to create a user which does not exist on SQL Server, you will get this error…


Basic SQL – How to attach a database to SQL Server

This post is part of “Overview of NAV-specific SQL features for application consultants“. If you receive a SQL Server database file (.MDF), then you must attach this to your SQL Server before you can access it. This is how to do that: 1)     Copy the Database file (.MDF), for example “Demo Database NAV (6-0)_Data.MDF” into…


Basic SQL – How to create a new NAV database for restoring a NAV backup

This post is part of “Overview of NAV-specific SQL features for application consultants“.    This post describes the steps needed to create a new NAV database from a NAV backup (.fbk) file. All the steps are done from a NAV client: 1)     Start a NAV client (finsql.exe), then go to File -> Database -> New….


Basic SQL – Enable trace flag 4616 on SQL Server

This post is part of “Overview of NAV-specific SQL features for application consultants“.   The newest versions of Microsoft Dynamics NAV require trace flag 4616 to be enabled on SQL Server. If not, then you will get this error message when you try to connect: === The trace flag 4616 is not set on the…