navteam articles
navteam
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
6 min read
Customizing style sheets for MS Excel
As of version 5.0, Dynamics NAV introduced the option to export forms to MS Office (Word or Excel).
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
2 min read
What are the Visual Studio options for developing RDLC reports for Dynamics NAV 2009
Updated 24. September 2009 to include options for Dynamics NAV 2009 SP1.
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