If for some reason you don't want to install the Windows client locally, you can also use a copy of the Role Tailored Client directory.
Please note that this scenario is not supported by Qucamba.
When running Qucamba Reports in an environment without having the client installed you should pay special attention to the following points:
- Copy the entire Role Tailored Client directory to a local drive.
- From the Dynamics NAV product distribution DVD install the ReportBuilder3.msi file located under Prerequisite Components\Microsoft SQL Server.
- From the Dynamics NAV product distribution DVD install the SQLSysClrTypes.msi file located under Prerequisite Components\Microsoft Report Viewer.
- Of course, you should also have the Report Viewer installed. If not so, also install the ReportViewer.msi file
- In the Dynamics NAV Role Tailored client directory, open the file Microsoft.Dynamics.Nav.Model.Tools.format.ps1xml and save it as UTF-8 e.g. by using Notepad.exe. Make sure that you overwrite the original file.
- If not yet installed, register the Dynamics NAV document types on your local system. You can get these types from a service tier (NST) installation. They're located under Addins\Document Report. Use gacutil /i from the Windows SDK to register the types. Alternatively, if you don't have the Windows SDK installed on your system you can run a powershell script that is provided by Qucamba Reports and located under %ProgramFiles(x86)%\Qucamba Reports\Scripts\QR-RegisterNavDocumentTypes.ps1. Just copy this script to the same local directory as you copied the types to and run it as an administrator.
- If you haven't installed any Dynamics NAV client on your local system yet, you'll also need to have the Microsoft Open XML SDK 2.5 for Microsoft Office installed. You can get this from the Dynamics NAV product distribution DVD as well. It's located under \Prerequisite Components\Open XML SDK 2.5 for Microsoft Office.
Please note that the previous steps are not required when you have the appropriate Microsoft Dynamics NAV Windows Client (aka "Role Tailored Client") installed regularly.
Again, this scenario is not supported by Qucamba and you'll have to get this running on your own.