- Download the latest HMS installation zip file
- Create SQL user called "Reporting" that has access to the required company database and DYNGRP role
- Un-zip and run the crystal decisions msi as well as the report viewer setup installation.
- Open the HMS installation folder located at …\Microsoft Dynamics\GP\HMS_Documentation_And_Install
- Extract the RV_Scripts_Reports.zip file
- Sort files by type. If on a 64 bit system delete all .sql files that do not end in _64
- Open SQL Management Studio (SSMS) and login with SA account and in upper left corner change the database to the company DB to run the reports in.
- Go back to explorer and select all SQL Files and right click and say open
- All the files should automatically open in SSMS and the DB should be set to the correct company database
- Run each SQL file and when success message shown close the file in SSMS
- Open Microsoft GP
- Open the HMS Setup window
- Set the report directory
- Set the user name
- Set the password
- Run a report and confirm it is working.
- When you open the report window and fill everything out please remember that if you do not have any report options you need to type one in and click save.
Installing HMS Report Viewer Print
Modified on: Tue, 7 Dec, 2021 at 3:13 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.