Monday, March 19, 2012

RTC Report Landscape Format without Printer Settings.


Hi all,

In Case of Report Development in Landscape Format, it was behaving wired. In need to select the printer orientation from the printer settings.

But later on i thought about the same and started searching on the web. Then From MSDN i found out that if the report settings in RDLC are done correctly then we don't need to change the printer settings everytime.

How Printed Report Settings Are Determined

IF The settings in the Report Properties dialog box on the layout of the report specify a standard paper size, Then the settings in the Report Properties dialog box on the RDLC layout but is overridden if you change the settings in the Print dialog box.

For more info, you can read the whole article from here.

For Standard Lanscape Page Size these are the setting for RDLC Reports.

Interactive  8.5in, 11in
Margin       1.5cm, 0in, 2cm, 2cm
Page Size    29.7cm, 21cm
Body Size   27.29206cm, 9.16692cm

I hope this issue was faced by most of developers.


Hi all Just a update in same post. The above method works only in NAV 2009 R2 and later. For Printing Report in Landscape Format in NAV 2009 SP1, just apply the hotfix before using above technique.

The hotfix is available for NAV 2009 SP1 here.  

Thanks & Regards,
Saurav Dhyani

Sunday, March 18, 2012

ZUP File / Personalization Settings in Navision Role Tailored Client.


Hi all,

I did some changes in the pages & Reports During run time and save the view.Now i wanted to revert those changes to the standard Navision settings.

In Microsoft Dynamics Navision Classic Client we can do this by deleting the zup file as this file store all the personalization settings.But what about the Role tailored Client?

For Role Tailored Client there are two ways to do it -

1) Delete the PersonalizationStore.xml.

This file is located at \Administrator\Application Data\Microsoft\Microsoft Dynamics NAV.This file is used to store all user changes like resizing the columns in the pages. You can delete this file, If you want to roll back all the changes.

The Problem with Way 1 is that it will delete all your settings, what if if you dont want to delete all personalization settings but selective setting. Here is the another way.

2) Go to Object designer, & Run Table 2000000080 Page Data Personalization.

This table contain a record for each personalization done by every user.
so you can filter the user and the object (Page,Report,XMLPORT) from which you want to delete the personalization settings. You cannot see the value that you set as it is stored as BLOB.Refer to screen below.



By Using Way 2 you can delete the selective personalization setting you want to delete.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/

Tuesday, March 13, 2012

Comman Navision Application Server (NAS) Error.


Hi all,

If we don't follow the installation & configuration of NAS properly we find a most common error.

The Event Viewer Shows it as
Event Type: Error
Event Source: Microsoft Dynamics NAV Classic
Event Category: None
Event ID: 1000
Date: 3/13/2012
Time: 4:43:21 PM
User: N/A
Computer: XYZ

How to Install Navision Application Server (NAS)?


Hi all,

While trying to install NAV Application Server(NAS), i faced lots of challenges. So i thought to prepare a How to install NAS.

Remember some Points before you start -

1) NAS Require a Windows Login to start.
This is because it is a service and it is not possible to define a database login in a service. So you need to create a login in the domain or on the server to do it.

2) SYSADMIN Rights to Windows Login in SQL Server.
Now you have your Windows login, but this login has NO rights yet in SQL-server. So you need to create that Windows-login in SQL-server and make him sysadmin. See the manual on how to do that in SQL.

Thursday, March 1, 2012

RTC Report It is not possible to instantiate the Visual Studio bridge.


Hi all,

As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions -

NAV 2009 R2    - is installed.
NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\
NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\

This approach has been working great for execution of Classic and RTC Clients.
However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error:

--------------------------- 
Microsoft Dynamics NAV Classic 
--------------------------- 
It is not possible to instantiate  the Visual Studio bridge. 
--------------------------- 
OK   
---------------------------

After searching for the error i figured out the issue was due to -
Design change in NAV 2009 R2 which uses the .NetBridge rather than the old Visual Studio bridge component.

Solution OR Work Around

The Visual Studio bridge files are included with the binaries in the NAV 2009 SP1 Classic Client folder
so we can avoid the above error by running REGASM.EXE to register the DLL.
The REGASM.EXE is included in the .Net Framework folder so executing the following command from within the NAV 2009 SP1 Classic Client folder will remove the error.


Steps to Resolve the issue

1) Start Command Prompt (* Run as administrator if windows 7)
2) Change directory to location where NAV 2009 SP1 classic is placed.
   In my case it is C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\Classic\
   So command is CD C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\Classic\.

3) Now find the Location of regasm.exe which is located in .NET Framework
   In my machine the path is C:\Windows\Microsoft.NET\Framework64\v2.0.50727\ (for 64 bit)
                                          C:\Windows\Microsoft.NET\Framework\v2.0.50727\ (for 32 bit)

4) Now in command prompt run the command
   C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe Microsoft.Dynamics.Nav.VisualStudioBridge.DLL (64 bit)
   C:\Windows\Microsoft.NET\Framework\v2.0.50727\regasm.exe Microsoft.Dynamics.Nav.VisualStudioBridge.DLL (32 bit)

* you can find Microsoft.Dynamics.Nav.VisualStudioBridge.DLL inside classic folder.

5) If everything is correct, you will receive a message "Type Registered Succesfully" as shown in image below.



Problem Resolved !

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.in/