NAV 2013 R2 Report layout design with Report Builder

I was travelling to Kochi, Kerala to conduct a 6 day session on NAV 2013 R2 topics to a bunch of guys from one of the Microsoft Partner. it was 3 months back and as client requested to demonstrate the topics in NAV 2013 R2, I upgraded my laptop with NAV 2013 R2 from NAV 2013 FP1.

During the training, when we reach the topics on Reports, I got a rude shock that my report layout design is not longer opening and its throwing an error as below (though I have visual studio 2010 installed in laptop) -

Normally I ensure to keep all dependent software of NAV installed right in my laptop. But this time I missed out the fact that NAV 2013 R2 is no longer compatible with Visual Studio 2010. Rather it needs VS 2012 or higher.

Now I got a situation here as I even don’t have the installable of Visual Studio 2012 / 2013 and I need to demonstrate the report designing features to my audience.

Fortunately with my installation of NAV 2013 (R2), the SQL Server 2012 express version was installed and along with that, the Report Builder 3.0 too was got installed in my Lapi. Though I was more comfortable in designing the reports in Visual Studio, but I quickly adapted to the new environment and managed the show perfectly. And trust me my audience was happy :)

So the fact is that -

• NAV 2013 R2 no longer uses Visual Studio 2010 for report layout design. Rather it looks for Visual Studio 2012 / 2013. 

• If you don’t have the Visual Studio 2012 / 2013, you can still manage to design the report using Report Builder 3.0. This is a component of SQL server 2012 reporting services and gets installed when you install SQL server 2012.
• Among the 2 report authoring tools, Visual studio is still the default report authoring tool. So even though you have the Report Builder 3.0 in your machine, you will see that NAV 2013 R2 is looking for Visual Studio 2012 / 2103 and still throwing the above mentioned error (picture).

• Open NAV 2013 R2 development environment.
  go to Tools > Options. the below mentioned screen will open -
  Change the ‘Use Report Builder’ property to ‘Yes’. The default value will be ‘’.
  Press ‘Ok’.

So to make NAV 2013 R2 use Report Builder 3.0, you need to change an option property in your NAV environment. To do the same -

Once this is done, NAV 2013 R2 will no longer look for Visual Studio 2012 / 2013 and will open the Report Builder 3.0 for designing the report layout.

Note: If you are interested in knowing the difference between designing the report in Visual Studio (Report Designer) and designing the report in Report Builder, you can check out the below url for more details -

Designing Reports in Report Designer and Report Builder 3.0 (SSRS)

Enjoy Reading. I will come back with more topics on report designing soon. bye for now

www.navisioncanbefun.com

Hi Guys. Thanks for following me for so many years and enriching my knowledge with your valuable comments and queries. it was always an wonderful experience.

Due to my hectic work schedule as well as I wanted to spend more time with my infant daughter, I have not written much here in last 2 years. In these years, so many things have changed (in Navision itself) and probably now is the time when I should take this blog forward further with the newer topics, newer features of newer NAV.

I got some spare money to spend on migrating this blog to my custom domain and maintain it at least for next 3 years. And I have budgeted it that way

So I have migrated all the posts from this blog to my new address Navision - the fun starts here but I am going to keep this blog alive for the time being. All my new posts will happen from my new blog address but you can always refer to my old posts either in the blogger domain or my new domain.

Unfortunately in the migration process, I could not migrate my followers (as Google friendConnect is discontinued) to new address. So those who used get automatic notification about my new post (and their avatar used to get displayed in header part of my blog), will no longer receive them. But dear followers, you can always subscribe to my new posts in my new domain.

You can check out my new blog in the following link -

Navision - the fun starts here

New features will be -

• topics on the newer version of NAV
• Videos
• Downloads on some interesting presentations / documents
• better reading window / option
• social sharing / follow option
• easy to subscribe

Happy New year and Happy reading

Quit, Break, SKIP, EXIT

One of my student asked the following question few days back and I just tried to answer them in simple language. You may already know those answer right.


"can u please tell me the diff. in quit/break/skip/exit in NAV & how to use it properly........"




Just to answer your question -

1. Quit 

Quit can only be used in Report, Dataport or XMLport. (Like Currreport.quit). It quits (come out from) the report or dataport or XMLPORT. If some processing of data happened before the quit statement, all of those data manipulations will be reversed (rolled back).

2. Break

Break can be used in 2 places -

a. in any loop (repeat..until) - This statement will break the loop and come out of the loop without further processing. All the data manipulation before this statement will remain intact.

b. In a report or dataport or XMLport. This statement will take you out from any trigger (like on prereport, Onpresection etc)

3. SKIP 

SKIP is only used in Report / Dataport / XMLPORT. This statement skips the iteration of a dataitem.

4. EXIT

EXIT normally used in functions / triggers to return a value. (say a function returns a numeric value -

Myfunction(integer A, Integer B) Integer---

EXIT(A+B);

-------------------------------------------------

Hope the above answer helps you. I will try to send a more detailed answer to you (with example) soon. Keep writing me your problems and ask ur freinds to send their problems to me too.


You can also send me a mail to snehanshu.mandal@gmail.com

Navision - How to find out Square Root / Cube Root?

We all know how to raise a number to the power n. Use the powerful nummeric function 'Power'.

NewNumber := POWER(Number, Power);
So Power(4,2) will result in 16.


But how to find out the roots (square, cuber or nth root)?

Simple use the same Power function - And just change the 'Power' parameter of the function.

So to find out the square root of say 16, use

Power(16,1/2); This will result in 4

to find out the Cube root of say 8, use

Power(16,1/3); This will result in 2.

to find out the nth root of any number just use -

NewNumber := Power(Number,1/n);

How to indent multiple lines of code in Navision

What to do if you need to indent several lines of Code (Just because youmade the changes in code lately) in any Navision Object? Will you do it manually one line at a time?

Don't despair. There is a simple way to do it -

To indent several lines of code, select those several lines and press TAB. The code indents with two spaces to the right, every time that TAB is pressed.

To indent several lines of code to the left, select those lines, and press SHIFT+TAB. This indents the code with one space to the left, every time that SHIFT+TAB is pressed.

Block indentation enables developers to indent several lines of code in only three keystrokes (one for highlighting the code and two for pressing SHIFT and TAB.)