Editing NAV 2018 report layouts with VS 2017

poppins

Hi everyone,

I am not able to edit report layouts with VS 2017.
The .rdl file is not even visible.
I have installed the following:
SQL Server 2016
NAV 2018 CU1
VS2017 Community Edition (see below for details on what I installed):

Microsoft Reporting Services Projects Extension

What am I missing?
Do I need to install something else? or is it something in the setup?

Thanks in advance

barandeniz

Report Design Gotcha
One of the things we sooner or later get into, is designing RDLC reports. The Development Client, opens Visual Studio 2017 on our machines, but it only showed the XML representation of the rdlc file.

Off course, the first results stated we need to install SQL Server Data Tools in Visual Studio, but after checking, this was already installed. I changed my search query to a more generic “Visual Studio 2017 rdlc design”, and found out there is a VSIX file from Microsoft here: https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftRdlcReportDesignerforVisualStudio-18001

After installing this, our RDLC layout showed properly.
For the people who are interested, we are using Terminal Server internally, and we were able to install the VSIX for everyone on an admin session. You need to execute VSIXInstaller.exe with an admin command and the path to the VSIX. This will install the file in the admin profile, and make it available for everyone.

VSIXInstaller can be found here:


C:\Program Files (x86)\Microsoft Visual Studio\2017\<version>\Common7\IDE\VSIXInstaller.exe
1
C:\Program Files (x86)\Microsoft Visual Studio\2017\<version>\Common7\IDE\VSIXInstaller.exe
making the command as follows:


vsixinstaller.exe /admin <path to vsix>
1
vsixinstaller.exe /admin <path to vsix>

Credit goes to:

https://nav-magno.be/2018/02/nav2018-gotchas/

davmac1

follow the mvps on twitter - you will learn a lot - some of it before you need it which is especially nice