How to change Nav Edit Report Layout button launcher to Visual Studio

(0) Share

Report

Posted on by Saifudin

255

Hi,

Does anyone know how to change the following button (Edit Layout) to launch Visual Studio instead of SQL Server Report Builder?

Reason : Visual Studio has lot more functionalities compared to SQL Report Builder. It will be faster that using export and import layout.

0451.Capture.PNG

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Saifudin 255 on at

Like (0)

Report

When i export the layout and open using Visual Studio, this will come out.

How to change that to layout design mode?

This is alternative step in case I cant change the default 'Edit Layout' button in the NAV Client App (Custom Report Layout)

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

For Visual Studio -- open Developer environment --> Go to tools --> Options --> Check Use Report Builder :- If it is Yes then change it No so report will open in Visual Studio (Ensure that visual studio in installed)

Was this reply helpful? Yes No
Saifudin 255 on at

Like (0)

Report

Yes I am aware in Developer Environment we need to change that, but that doesnt change the behaviour in the NAV Client App ('Edit Layout'). I wish I can change that.

However, for the time being, I export the RDLC report and save it as *.rdlc instead of *.rdl and open the file using Visual Studio. Once completed then I need to import in.

If only I can change that edit layout button, that will make the report customisation a breeze.

Was this reply helpful? Yes No
Suggested answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report

Hi,

I tried sneaking bit into the code. I ended up in Codeunit 9650 which only allows either word based report editing or SSRS based.

What you can probably do is, you can save the report in .rdlc format and open via Visual Studio like this: https://msdn.microsoft.com/en-us/library/ms252067.aspx

Hope it helps.

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (3)

Report

Hello ASA,

you have to change the Registry

this is the registry path: HKEY_CLASSES_ROOT\MSReportBuilder_ReportFile_32\shell\Open\command

Here default is SQL Report builder, you have to replace with your VS report builder

Once you double click on Default it going to be editable.

See the bellow screenshot.

Was this reply helpful? Yes No
Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (3)

Report

Hi ASA,

Binesh's solution is working. If you are wondering what to replace with the registry value,

If you are using,

Visual Studio 2010 -> C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe "%1"

Visual Studio 2012 -> C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv.exe "%1"

Visual Studio 2013 -> C:\Program Files (x86)\Microsoft Visual Studio 12.0\Common7\IDE\devenv.exe "%1"

Visual Studio 2015 -> C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe "%1"

Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

This question and above discussion given me idea for a simple customization.

I have published a blog as a solution to this query, hope you may find useful please have a look:

msdynamicsnavashwinitripathi.wordpress.com/.../open-report-design-in-visual-studio-from-custom-report-layouts

This place is not only great for solution but for ideas too for on which topic we should write blogs.

Great discussions and ideas.

Was this reply helpful? Yes No
Saifudin 255 on at

Like (0)

Report

Hi,

I was able to edit the registry and make the VS launcher from NAV App. However, I got to this screenshot instead of the VS report layout view.

Any idea?

Was this reply helpful? Yes No
Suggested answer

Binesh 7,885 on at

Like (0)

Report

Hello ASA,

You got that, because your file is .rdl, you have to also change the file extension rdl to rdlc

for better result, see the links provided by Ashwini Tripathi, or you can see by click Here.

Was this reply helpful? Yes No