Thursday, June 30, 2011

RTC Report Development 2

Hi all,

If you havent read the part first then read it here.

Now when you created the sugggestion layout you can see the Red Dots in the Report body. For being specific in the table details of the first table in the Page Body.

The most part of an RTC Report is the Page Header, we all face issues in this.

Let's discuss what happens when we say suggest layout.

Wednesday, June 29, 2011

RTC Report Development 1

Hi all,

we all have some known and unkown issues while creating a Report For Role Tailored Client.
we will try to create a standard report by deleting its Layout and creating a new RDLC Layout from Scratch.

I have saved Standard Report 406 Purchase - Invoice as 5000 Purchase - Invoice 1.
Then i deleted its existing layout by using Tools->Delete Layout.

Now lets create the Layout from Scratch.
Now lets see what Layout suggestion suggest for this report, by using Tools -> Create Layout Suggestion.

Friday, June 17, 2011

Microsoft Dynamics NAV Classic client was opened from an untrustworthy component. Contact your system administrator.

Hi all,

A Comman error faced while trying to Run a Report From Role Tailored Client (a report with no layout defined), it try to start the Report Engine from classic Client.

It can happen that after updating RTC, you end up with a version of RTC which is not compatible with the default classic client. In this case you will typically get this error message when trying to run the report.

First of All you need to find the build of classic and Role tailored client. The Build for both should be same.
Following screen shows how to check the build for both client.

If the build is diffrent you need to udate the Build using this link (require Partner/Customer source login).

If the build is same then we need to find out from where does RTC find the classic client for running classic reports?

RTC finds the location of Finsql.exe in this place in registry: (can be opened by typing regedit in RUN)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\
Check the value for Default and Path, that should be the exact location where the classic and role tailored client is installed.

So if you have any of the issues above, make sure that the classic client in this folder matches the version of RTC.

Saurav Dhyani

Sunday, June 12, 2011

Starting the RoleTailored Client from a Command Prompt

Hi all,

we all face situations where clients ask for some specific requirement as per user, as in he want that user cannot see anything other than a certain page or something like this. By using command line parameters we can achieve that.

You can start the RoleTailored client at a command prompt. By adding command-line parameters, you can:

Start the RoleTailored client with a profile other than the default profile.
Configure a profile.
Start the RoleTailored client with a language other than the default language.
Start the RoleTailored client with client settings other than the default client settings.
Start the RoleTailored client and open the specified page.
Start the RoleTailored client and open the specified report.

To run the RoleTailored client at a command prompt, open a command-prompt window and navigate to the RoleTailored client directory. The default location is: Program Files\Microsoft Dynamics NAV\60\RoleTailored Client

The executable name is: Microsoft.Dynamics.Nav.Client.exe

You can also start the RoleTailored client from the address bar in a browser or from a Run window using the same options. To start the RoleTailored client from a browser, type DynamicsNAV://<Server/ServerInstance>/<Company>/

Command-Line Parameters

You can use the following parameters when you start the RoleTailored client at a command prompt.

-?                         Displays this list of parameters.
URL                         Opens the RoleTailored client to a particular page or with a particular report.
-profile: id          Starts the RoleTailored client with the specified profile.

-language: id           Starts the RoleTailored client with the specified language.                       
-settings: file          Starts the RoleTailored client with the specified settings file.

-failurestacktrace    Sends the stack trace for the RoleTailored client to Windows Clipboard.

-disablepersonalization       users are not able to personalize.

-configure              Starts the RoleTailored client in configuration mode. Use configuration mode to configure 
                               a profile.

The best one I find is  -?

It tells you about all the options we can have in RTC while running from command line. And at the same time it gives you example of all the commands discussed above.

Output when we run the command prompt parameter -?. 

These commands can be used to create shortcuts for RTC with the parameter discussed above and the user will get what he wants, when he start RTC with the Shortcuts.

Saurav Dhyani

Thursday, June 9, 2011

User ID and password are invalid.try again?

Hi all,

If you get “User ID and password are invalid.try again?” when starting RTC you need to first check that you can login to database in the classic client.

Reason for the Error

Windows Login is not synchronized with Database.
 You are trying to connect a database which does not have your windows Login.


Try to open database in Navision Classic Client with Windows Authentication.
If it fails open database with Database Authentication.
Click Tools, Security, Windows Login.
Create windows login, set a Role and Synchronize the Login.

Now try to connect Classic client with windows authentication.
If you are able to login then try to open Role Tailored client.

If you still get same error check the database name in CustomSettings.config file.
(c:\Program Files\Microsoft Dynamics NAV\60\Service\CustomSettings.config)

If it doesn’t to connect to the database start SQL server manager and verify that the windows user have permission to login and use the NAV database.

Saurav Dhyani

Wednesday, June 8, 2011

Statement of Direction for Microsoft Dynamics NAV

Hi all,

Most of us always trying to find out about the future release of Microsoft Dynamics Navision.
Microsoft have released the statement of Direction for Microsoft Dynamics Navision.

Document contain the major release plan from now till 2016-2017, and the gimps of changes that will happen in Navision future Release.

The document can be downloaded from here with login credentials for Partner Source.

Saurav Dhyani

Tuesday, June 7, 2011

Microsoft Windows XP Multilingual User Interface

Hi all,

While Trying to open a database that is created in navision client with country  specific version we face the error shown below.

Error in Classic Client

Error in Role Tailored Client

In my case i have installed NAV 6.0 R2 (IN) and the database is created in NAV 6.0  R2(GR).

As per the message user click OK (in classic) and the database get opened in classic client, but what happens when we try to open the Role Tailored Client.

Out of our imagination there comes the error-

and there is no resoultion for same.

Issue Resolution

First we need to Download the Language Pack of Specifice Language from here.

In my case i require the Greek Language Pack,download it and install it.
Now we need to do some setting in Regional Settings in Control Panel, as shown below.

Hit Apply after changing language in Regional Options and Advanced tab.
It will ask to restart computer restart it.
Restart the comupter, then start classic or Role Tailored Client, it will start without any error.

Saurav Dhyani

Monday, June 6, 2011

Change Drill Down in the Page?

Hi all,

A freind of mine asked me yesterday that one of his client want to change the Drop Down option in RTC Page.

As shown in image below, and client says that when he want to choose item No. he don't want No.,Description,Base Unit of Measure,Bill of Materials,Unit Price.

Insted of it he want No.,No. 2,Description,Unit Price,Inventory Posting Group,Vendor No.

Yes this can be changed.

Goto the source Table of that page which is getting opened during drop down, in our case its item table.
Design the table and from the view menu you can access the Field Group as shown in picture below.

Here you can set the DropDown Menu as per customer requirment.

Below is the image that shown the changes i have done on the same.

Save the changes in the table and start RTC to see changes in the Drop Down Menu.

Finally we have achieved what we wanted.

There are somethings to remember -

1) It will change the DropDown for all the places where item will get lookup.
2) You cannot or i should say should not change the name of the Property, that is HARD CODED as DropDown. Any name other than this will not work.

Saurav Dhyani.

Friday, June 3, 2011

Debugging of Client Add in

Hi all,

Debugging of an Add-in in the client is very simple. After the client has started up all you need to do is to attach the Visual Studio to the process of the Role Tailored client.

For debugging compile your project with the “Debug” solution configuration.

Before you open the page that contains your Add-in attach Visual Studio to the process “Microsoft.Dynamics.Nav.Client.exe”.

Now you can monitor the program flow in your Add-in code. Go ahead and set breakpoints in the implementation of CreateControl or in your implementation of the IObjectControlAddInDefinition interface.

รจIf you find to do the above steps to be difficult there is an another method to do same task.

Then consider adding the following code line in the CreateControl method:


This will fire up a dialog where you can pick the instance Visual Studio and for debugging and already breaks at that code line. Remember to remove this line, when you are done with debugging ;-)

I would personally suggest using first method as there is no chance of missing something in code after debugging is completed. Give it a try!

Saurav Dhyani

Thursday, June 2, 2011

Use Boolean Variable in Page Property.

Hi all,

­­­­we all have read in Microsoft manuals for NAV 2009 Page Development that most of the page control properties are not limited to values yes and no. Now developer can use a Boolean variable and change the property value on the runtime by using that Boolean variable at run time.

But what, when I first tried to use same if didn’t worked and I was amazed so I re- read the manuals but didn't find any resolution for the same.

I put the query in formulas and then someone told me that what need to be done if we are using any Boolean variable for any property.

Problem –
Boolean variable doesn’t work as expected when used in property for pages.

Resolution –
For the Boolean field we want to use in the page property, there is a property called INCLUDE IN DATASET that needs to be set to YES.

Once done it will work as expected by you.

Saurav Dhyani 

Wednesday, June 1, 2011

Extended Stored Procedure xp_ndo.dll Error (64 Bit)

Hi all,

When we install navision 2009 and later on 64 bit operating system, most of us get error like shown below while we try to connect Role Tailored Client or Classic with Windows authentication.

The error says -

The following SQL server error or errors occurred:
17750,“42000”,[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:Program Files (x86)Microsoft Dynamics NAV60Databasexp_ndo.dll, or one of the DLLs it references. Reason: 193(failed to retrieve text for this error. Reason: 15100).
INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}

Reason For Error
Installed xp_ndo.dll is 32 bit and not 64 bit.

 Replace xp_ndo.dll with the 64 bit version.

Steps to Follow

1. Stop SQL server
2. Copy xp_ndo_x64.dll from installation DVD  to C:Program Files (x86)Microsoft Dynamics NAV60Database
3. Rename existing xp_ndo.dll to xp_ndo_x32.dll
4. Rename xp_ndo_x64.dll to xp_ndo.dll
5. Start SQL server.

Saurav Dhyani