Hi all,
As promised in earlier post that I will try to figure out the way to run
classic report from Role Tailored client which is not installed on my machine.
One of my post I
explained that from where Role Tailored client find the path of classic client,
I am just using that.
My machines have NAV 2009 SP1 Installed. I went to registry editor
(regedit.exe) to find the key where the information of classic client in
stored.
As you can see in the screen shot above (FOR WIN 7) that the information
about classic client is stored in
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS\CurrentVersion\App
Paths\finsql.exe
Go to File & select Export and save the registry file on desktop with
Name say NAV Classic for NAV 2009 SP1. Now open the file in notepad.
The selected line shows the path of finsql that need to start when we
execute a report whose RTC Layout is not created.
Let’s change the file and make changes for other versions (NAV 2009 &
NAV 2009 R2) classic default Path.
I saved the file with name NAV Classic for 2009 & NAV Classic for
2009 R2 and here how they looks.
Let’s create a new Report in NAV 2009 R2 say Test Report and try to run
that report from RTC.
As expected I got the error.
Now let’s add information for classic client in Registry for NAV 2009 R2.
For this just double click the registry file that we have created for NAV 2009
R2.
An Warning will appear, click yes.
Now let’s again try to run that report. (during this operation the RTC
Client should be closed).
And it’s done.
You can restore the path of default version but just clicking on the
registry file that we have saved in the first step.
Thanks & Regards,
Saurav Dhyani
Hey, just a heads up, if you want to change the registry in Windows XP you should do it like this instead:
ReplyDelete"Path"="C:\\Program Files\\Microsoft Dynamics NAV\\60\\Classic\\"
@="C:\\Program Files\\Microsoft Dynamics NAV\\60\\Classic\\finsql.exe"
First the path and then the @ (default), otherwise it won't work.
Thanks for the help, this post was very helpful! Cheers
Hey Luis thanks for the update, i missed that part.
ReplyDeleteThanks if you find the post helpful! Cheers
If you find this registry key to be a problem, then please vote for a fix here: https://connect.microsoft.com/dynamicssuggestions/feedback/details/716463/allow-multiple-rtc-versions-on-the-same-computer
ReplyDeleteThanks in advance
@ PDJ Done.
ReplyDeleteHey there Saurav, I was wondering around the Internet and couldn't find an answer to a problem I have and since your blog was the one that solved my prior issue I just wanted to ask you something:
ReplyDeleteCan I run a page on SP1 Classic, when I have R2 installed, and make it open SP1 RTC instead of R2 RTC like it does?
Many thanks in advance!
Hi Luis,
DeleteThanks for the query.
I will look for the solution for the issue and will revert you back for sure.
Just to confirm that i understand it correctly - you have both SP1 & R2 RTC running on single machine and both services running.
You want to run a page from classic client that is on SP1 and want to open the specific RTC version from there.
Regards,
Saurav Dhyani
Yup, exactly that case :)
DeleteHi Luis,
DeleteI found out a link which full fill your requirement.
Please have a look on it at http://blogs.msdn.com/b/nav/archive/2009/11/17/how-to-run-2-rtc-on-the-same-pc-and-connect-it-to-different-db-how-to-run-pages-reports-from-diff-db.aspx
i think this being done for multiple instance of Navision RTC but same version. I will be testing it next week as i am on holiday and will be trying to do it for different versions also.
You might use it in the mean time. Let me know if any other input required.
Thanks & Regards,
Saurav Dhyani