navteam articles

navteam
Published 
1 min read

Installing Stored Procedures for Dynamics NAV 2009 Manually 

It’s recommended that you use the installer on the product DVD to install the stored procedures. But if you are running more than one name instance of SQL server on the same machine that approach will not work. Then you need to do it manually:1. Copy the xp_ndo.
Published 
1 min read

Filtering out blank fields 

Some of you have noticed that the Chart displayed in “Customer Order – Summary” contained a series label called Series 1. Well the reason for that being shown is because we have missed to filter out all customer with have no data in the field: Chart_SalesOrderAmountLCY.Value So how is that actually done?
Published 
3 min read

Updated April 2nd 2009 – How to add a Company Picture to a Report 

UPDATED April 2nd 2009: Several people have reported to me that the first solution I posted for “How to use the Picture stored in Company Information table:” did not work for them. So I have now updated the section on how to use the picture stored in the Company Information table.
Published 
2 min read

How to get a Dynamics NAV report with a Web Service 

1. Create a new codeunit. In this scenario we will call this codeunit “CUWebReport” with ID 50000 2. Navigate to “C/AL Globals” and create a function called “GenerateReport” 3. Select “Locals” 4. Select the “Return Value” tab 5. Set “Return Type”=Text and “Length”=100 6. With this completed close “C/AL Locals” window. 7.
Published 
2 min read

Installing the NAV 2009 demo database to a SQL Server named instance 

One of the questions that has been raised frequently is how to install the Dynamics NAV demo database to a named instance of Microsoft SQL Server using the new installation program that was released with Dynamics NAV 2009. The short answer to this question is that this is not supported.
Published 
1 min read

Dynamics NAV 2009 and MS Office Integration, send-to Excel and Word 

This blog describes changes in office integration feature, send-to Excel and Word, when using RTC client in NAV 2009. Send-to menu option on RTC client is typically located in menu, under Actions – Send to option. Shortcuts for this functionality is added, but unlike version 5.0, only send -to Word and Excel options are available.
Published 
4 min read

Automation Objects in Microsoft Dynamics NAV 2009 

Overview The Automation object is often used to integrate NAV business logic with external processes and thereby extend the functionality of the product, such as integration with other products like Office.
Published 
3 min read

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.
Published 
3 min read

Dynamics NAV and export to Excel: Export dates as true excel dates 

When running Send-to Excel functionality and exporting data to MS Excel using style sheets, all data exported form NAV is formatted as either numbers or strings. That also includes dates, that are exported as strings and not formatted as true dates in excel. As of update 1 for NAV 5.0 SP1, data.
Published 
5 min read

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.