How to reflect the changes in MS Navision Sql server to MS Navision classic client


when i made changes in MS Navision Sql server then it not reflect to MS Navision client.Please suggest me how to reflect my changes which i made on MS Navision Sql server version to MS Navision classic client version.i used the Navision 2009 R2 version.

Thank you.

What exactly do you mean? If you delete a record directly from the SQL Server, then it will still be in the NAV client? Or which kind of changes do you talk about?

Hello Erik,

There are two part in navision one is Microsoft Dynamics NAV 2009 R2 Classic With Microsoft SQL Server and other one is Microsoft Dynamics NAV 2009 R2 Classic Client.when i create the new report or form or made any changes to existing report and form in Microsoft Dynamics NAV 2009 R2 Classic With Microsoft SQL Server that should reflect on the Microsoft Dynamics NAV 2009 R2 Classic it possible if yes then how i publish the report or form.

if not then how to customize changes in Microsoft Dynamics NAV 2009 R2 Classic Client.

Thank you.

The two NAV is a very different, in the database they are using.

One is using SQL Server, and the other one is using NAV Native Database.

Since, the DB is different, let’s say DB Production and DB Testing, they are different completely, with regards of the records and the objects.

Hence, what you are do (any changes) in SQL Server, could not reflected in Native DB, and vice-versa.

If you want to publish a new objects (form/report, etc.), then you should export your object from 1 DB, to another DB (import).

IF it is two different database then it will not reflect any changes in either databases.

IF you have two different company in sames database then it will reflect.

Best way export the object from one database and import it in another database.


its a single database not two different database but it contain the two company.i used same database and same company,my need is when i create one report or made changes in existing report then that report should reflect From Microsoft Dynamics NAV 2009 R2 Classic With Microsoft SQL Server To Microsoft Dynamics NAV 2009 R2 Classic Client.

i attached image as shown in image.

As per image it is SQL Database and second is RTC client and not classic client .In NAV 2009 SP1 and NAV 2009 R2 version there are three client Classic,Classic with SQL and RTC client

IF you change anything in existing report then of classic then it should reflect in RTC client.

I suggest kindly check which database is opening when you click on RTC client. I strongly feel that your are doing changes in one database and looking at another database.

Check the CustomSettings.config file in C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service

Hi Amol,

i check the CustomSettings.config file here the database name is same as both place in database name and company name but still it not reflecting on the RTC Client from classic with SQL is it required to publish report or any other configuration or setting required.Please suggest some solution ASA posible.

Thank you.

Restart the NAV service and check .

Restart the system as well as NaV services but it not work.

i attached the images which report that i want the formate like that

If you have added the fields in classic client report (sections) then they wont reflect in RTC automatically.

you need to change rdlc layout of the report also in order to show those fields…

then how i made changes in form

what do you mean by form/report?

Hi Mohana,


i also made changes on form so i want that changes also reflect on the RTC Client.

i understand about report on layout and add field in visual studio but how open form in visual studio it not showing the layout properties.

is there any direct method to reflect from classic client to RTC client.

thank you.

There is no method for directly reflecting any change made in classic report to RTC report .

You have to do the changes in RDLC layout for the same.

You can open in from View–>Layout when report is opened in design mode.

But you need some training before doing it.

Yes,i understand about Report but how we can open form and page in visual studio and reflect their changes in RTC client side.

Why to open Page in visual studio ??

You can design the page /form in Na vision by click on design button .Once you done changes in Pages it will reflect in RTC client.

when i made any changes on Report or Form or Page in classic client with SQL then it not reflect the changes on RTC Client.i try multiple time but it not happen.


when i add on field of user id on report or form in classic client with SQL then these added field will not shows on RTC client when i run the same Report or Form.

i need to display the added field on the RTC client.

It really sounds like you’re not accessing the same database with the rtc as you are accessing from the classic client.

A way you can test this is to try to change some of the data. Eg. try to make a change to a specific customer no. and then check that the changes is also done in the RTC. If the changes is in the RTC, then you do have access to the same database. If not, then you do not have access and you’re back to getting your NAV service CustomSettings.config setup correctly.

So please confirm or deny that record changes done in the classic and rtc are synchronized. If data are not “synchronized” then your objects are also not synchronized.