Report Builder has limitations like: you do not have a document outline view, fields that you add to the table in the development environment are not added automatically to the report dataset in Report Builder etc. It also shows how we can design reports using SQL report builder. Watch the following short video which demonstrates changing between 2 report designers in Microsoft Dynamics NAV 2013 R2. Now, when you try to alter an existing report layout or design a new report layout (development environment–> Report –> Design/New –> View –> Layout), SQL Server Report Builder opens up for the layout design.ĭesigning reports in this tool is quite similar to Visual studio report designer. This is the switch between the Visual studio report designer (Use Report builder: No) and SQL server report builder (Use Report builder: Yes) for design/modification of reports. So, if you have NAV 2013 R2 development environment installed, open Development environment, click on Tools –> Options and change the value of Use report Builder to Yes Microsoft Dynamics NAV 2013 R2 Setup installs Microsoft SQL Server Report Builder for Microsoft SQL Server 2012 if development environment is included in the installation. In instances where customers who do not have access to Visual studio but need small adjustments in their reports, SQL Server Report Builder will come in handy!
![sql report builder 2012 sql report builder 2012](https://i.stack.imgur.com/Np70F.png)
![sql report builder 2012 sql report builder 2012](https://i.ytimg.com/vi/ZV12YeROtvQ/mqdefault.jpg)
The Visual Studio Report Designer is the default report designer and it provides design functionality that SQL Server Report Builder does not support. 55005 Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and SQL 2012 training course by Nicomp is offered at any of our locations around the. My previous post on reporting shows which tools can be utilized to design reports in Dynamics NAV 20 R2.