Report designing in NAV 2013/2013 R2 – Beginner
Before we get into design of reports in Microsoft Dynamics NAV 2013 and Microsoft Dynamics NAV 2013R2, its important to understand what’s required.
Apart from access to NAV development environment and developer’s license, the following are required:
>>To Design reports in Microsoft Dynamics NAV 2013 we require Microsoft Visual Studio 2010 SP1Professional, Premium, or Ultimate.
>>To Design reports in Microsoft Dynamics NAV 2013 R2 we need to use:
Microsoft Visual Studio 2012/2013 Professional, Premium, or Ultimate edition (Microsoft Visual Studio 2013 is only supported if Microsoft Dynamics NAV is updated according to Knowledge Base article 2907585.)
Microsoft SQL Server Report Builder for Microsoft SQL Server 2012/2012 Sp1 or Microsoft SQL Server 2008 R2 Report Builder 3.0 (Microsoft Dynamics NAV 2013 R2 Setup installs Microsoft SQL Server Report Builder for Microsoft SQL Server 2012 if it is not already installed on the target computer.)
In NAV 2013 R2, you can choose to design or modify the report layout using Visual studio or SQL Server Report Builder. You can switch between these 2 designers by going to development environment–> Tools–> Options–>Use Report Builder(yes or No)
please note : The Visual Studio Report Designer provides design functionality that SQL Server Report Builder does not support. For example, in Report Builder, you do not have a document outline view. Also, fields that you add to the table in the development environment are not added automatically to the report dataset in Report Builder.
Report Builder functionality that requires access to a SQL Server Reporting Services server is not supported. This includes running the report from Report Builder, and adding Report Parts.
I have referred to multiple videos from Microsoft’s channel on YouTube in this post. It showcases how we can build reports in NAV using Visual studio from scratch.
Simple List Report in Microsoft Dynamics NAV 2013
The first video in this section shows how easy it is to build a simple Customers list report in Microsoft Dynamics NAV 2013 with page header, page footer, image etc.. from scratch. This is a great video for the beginners. The output of the report is shown in the below image:
This following video explains How to: Build a simple list report in Microsoft Dynamics NAV 2013 using Visual studio 2010. You can try this report in NAV 2013 R2 with Visual studio 2012/2013 as well: